Posted by Bishman on 09/21/06 21:55

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.

• Next in forum: Re: QUESTION: Performance issue on *one* database on a server
• Prev in forum: Re: Using USER value in SQL code
• Thread view: SSIS Newbie help please.

[Reply to this message]