CODEWITHSUNDEEP
sql-serverssiscompatibility
Eric W
Eric W

Reputation: 662

SSIS 2008 on SQL Server 2005?

Is there any way to get the benefits of SSIS 2008 (including the performance improvements) while still working with a SQL Server 2005 database? It seems like it still pulls the data from OLE, so I don't see how it would be a problem. I'm running the package from the dtproj file, not loaded onto the server.

Upvotes: 4

Views: 2492

Answers (2)

Sam
Sam

Reputation: 7678

I have asked microsoft licensing and installing 2008 components on a 2005 instance can be done at no extra charge. We plan on doing this for reporting, but still want to install 2005 on the server to do some warm-standby mirroring.

edit: I assume you would need software assurance (somewhat obvious, but otherwise you would have to pay for the 2008 upgrade anyway.)

Upvotes: 1

SQLMenace
SQLMenace

Reputation: 135181

there is no problem using a 2005 or 2000 or even a version 7 DB However I don't think you can install SSIS 2008 on a box that has SQL Server 2005 on it since you will most likely need to pay for a separate license

Upvotes: 3

Related Questions