|
|
Posted by Bishman on 09/23/06 19:57
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
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.
>>
>>
>
>
Navigation:
[Reply to this message]
|