CODEWITHSUNDEEP
sql-server-2005ssis
dtc
dtc

Reputation: 10296

Can a SSIS package created with VS.net 2008 access a SQL Server 2005 database?

Can a SSIS package created with VS.net 2008 access a SQL Server 2005 database?

Package is created in VS.net 2008. Actions/methods in the package will read and write from/to a SQL Server 2005 database.

Package would be executed/run from an SQL Server 2008 server.

Is this a supported scenario?

My DBA says no, but my thinking is this would be like if you made a VS.net 2008 SSIS package that accesses Oracle/DB2/Flat file. Wouldn't SQL Server 2005 be just a data store in this case?

Upvotes: 0

Views: 263

Answers (2)

HLGEM
HLGEM

Reputation: 96650

We ran many SSIS pacakages from a SQL Server 2008 database that got data from a SQL Server 2000 database before we upgraded all the databases. Your dba is incorrect.

Upvotes: 2

bobs
bobs

Reputation: 22224

SSIS can access any SQL Server database version. There is an OLE DB source component that will do this.

Upvotes: 5

Related Questions