Hi,

I am trying to export rows from SQL2005 linked to coresponding rows from
Oracle to an Excel spreadsheet using SQL Server 2005 Integration Services
(DTS as it was)

I really am not sure what I ought to be attempting to do, however I seem to
be able to create two OLE DB source 'objects' and have tried using the
'Export Column' 'Union All' and 'Copy Column' objects to 'link them to an
'Excel Destiantion' object.

Is this along the right lines ??!!

I had all sorts of varied errors along the way which led me believe This may
not be right.

I have not been able to find an example of how this should be accomplished.
Can anyone point me in the right direction of a tutorial / relevent webcast
please ? I have seen the MS webcasts but they dont seem to be aimed at
begginers. I was reasonably experienced with DTS and simply cannot get my
head around the leap from DTS to SSIS.

Thanks

Jon.

> I really am not sure what I ought to be attempting to do, however I seem
> to
> be able to create two OLE DB source 'objects' and have tried using the
> 'Export Column' 'Union All' and 'Copy Column' objects to 'link them to an
> 'Excel Destiantion' object.
>
> Is this along the right lines ??!!

There are a few different ways to approach the problem but I don't think
these tasks are particularly useful in your situation.

In order to 'link' the SQL/Oracle data, you could include one of the sources
as a Lookup. You can then either exclude the unmatching rows or take some
other action depending on your needs. Another approach is to sort data from
each source and then combine with Merge Join.

> Can anyone point me in the right direction of a tutorial / relevent
> webcast
> please ? I have seen the MS webcasts but they dont seem to be aimed at
> begginers. I was reasonably experienced with DTS and simply cannot get my
> head around the leap from DTS to SSIS.

Check out http://www.sqlis.com/

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Bishman" <jonathan.bishop@btinternet.com> wrote in message
news:9P-dnTBUPv_Tl47YnZ2dnUVZ8qKdnZ2d@bt.com...
> Hi,
>
> I am trying to export rows from SQL2005 linked to coresponding rows from
> Oracle to an Excel spreadsheet using SQL Server 2005 Integration Services
> (DTS as it was)
>
> I really am not sure what I ought to be attempting to do, however I seem
> to
> be able to create two OLE DB source 'objects' and have tried using the
> 'Export Column' 'Union All' and 'Copy Column' objects to 'link them to an
> 'Excel Destiantion' object.
>
> Is this along the right lines ??!!
>
> I had all sorts of varied errors along the way which led me believe This
> may
> not be right.
>
> I have not been able to find an example of how this should be
> accomplished.
> Can anyone point me in the right direction of a tutorial / relevent
> webcast
> please ? I have seen the MS webcasts but they dont seem to be aimed at
> begginers. I was reasonably experienced with DTS and simply cannot get my
> head around the leap from DTS to SSIS.
>
> Thanks
>
> Jon.
>
>

Thanks Dan.

I went for the MergeJoin and it seems to be doing the trick !

Jon



"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
newsuIQg.4047$e66.1022@newssvr13.news.prodigy.co m...
>> I really am not sure what I ought to be attempting to do, however I seem
>> to
>> be able to create two OLE DB source 'objects' and have tried using the
>> 'Export Column' 'Union All' and 'Copy Column' objects to 'link them to an
>> 'Excel Destiantion' object.
>>
>> Is this along the right lines ??!!
>
> There are a few different ways to approach the problem but I don't think
> these tasks are particularly useful in your situation.
>
> In order to 'link' the SQL/Oracle data, you could include one of the
> sources as a Lookup. You can then either exclude the unmatching rows or
> take some other action depending on your needs. Another approach is to
> sort data from each source and then combine with Merge Join.
>
>> Can anyone point me in the right direction of a tutorial / relevent
>> webcast
>> please ? I have seen the MS webcasts but they dont seem to be aimed at
>> begginers. I was reasonably experienced with DTS and simply cannot get my
>> head around the leap from DTS to SSIS.
>
> Check out http://www.sqlis.com/
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Bishman" <jonathan.bishop@btinternet.com> wrote in message
> news:9P-dnTBUPv_Tl47YnZ2dnUVZ8qKdnZ2d@bt.com...
>> Hi,
>>
>> I am trying to export rows from SQL2005 linked to coresponding rows from
>> Oracle to an Excel spreadsheet using SQL Server 2005 Integration Services
>> (DTS as it was)
>>
>> I really am not sure what I ought to be attempting to do, however I seem
>> to
>> be able to create two OLE DB source 'objects' and have tried using the
>> 'Export Column' 'Union All' and 'Copy Column' objects to 'link them to an
>> 'Excel Destiantion' object.
>>
>> Is this along the right lines ??!!
>>
>> I had all sorts of varied errors along the way which led me believe This
>> may
>> not be right.
>>
>> I have not been able to find an example of how this should be
>> accomplished.
>> Can anyone point me in the right direction of a tutorial / relevent
>> webcast
>> please ? I have seen the MS webcasts but they dont seem to be aimed at
>> begginers. I was reasonably experienced with DTS and simply cannot get my
>> head around the leap from DTS to SSIS.
>>
>> Thanks
>>
>> Jon.
>>
>>
>
>