> 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 ??!!

> 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.

"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.
>
>

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:DuIQg.4047$e66.1022@newssvr13.news.prodigy.com...
>> 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.
>>
>>
>
>