SSIS connecting to SQL Server 7

microsoft.public.sqlserver.tools

30 Oct 2007 2:26 PM

PhilHibbs

Is there any reason why an SSIS package can't be used to connect to an
SQL Server 7 database and extract data from it?

Phil Hibbs.

31 Oct 2007 5:46 PM

NigelA

No reason at all. As long as you have the appropriate ODBC connectors you
can connect to anything. You may find that you have to use an OLE DB Source
rather than a DataReader source. Not sure how the DataReader Source would
play with SQL Server 7

Nigel Ainscoe

Show quote

"PhilHibbs" <sna***@gmail.com> wrote in message
news:1193754397.801705.187920@22g2000hsm.googlegroups.com...
> Is there any reason why an SSIS package can't be used to connect to an
> SQL Server 7 database and extract data from it?
>
> Phil Hibbs.
>