|
|
Posted by Dan Guzman on 09/22/06 03:10
> 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]
|