patternMinor
Can I downgrade SSIS packages to run on older version of SQL
Viewed 0 times
canversionolderssissqlpackagesrundowngrade
Problem
We have some new SQL 2008 SSIS jobs that were recently developed, mostly to do some simple flat-file loading and targeting a set of tables on a 2008 server.
As it turns out, they may have to run on a SQL 2005 server for both the SSIS and target tables.
Is it possible to downgrade the packages somehow, instead of redeveloping them from scratch?
Obviously any 2008 specific SSIS features would disappear; but it would be nice to not start with a blank designer screen.
As it turns out, they may have to run on a SQL 2005 server for both the SSIS and target tables.
Is it possible to downgrade the packages somehow, instead of redeveloping them from scratch?
Obviously any 2008 specific SSIS features would disappear; but it would be nice to not start with a blank designer screen.
Solution
A second option would be to run the SSIS packages on ServerA2008 and set the connection managers for your source/destination to be ServerB2005. No code change required and you should be able to continue using the 2008 features.
One caveat to this approach is it will not work if you use the "SQL Server Destination" component as it requires the package be executed on the same machine as the destination.
One caveat to this approach is it will not work if you use the "SQL Server Destination" component as it requires the package be executed on the same machine as the destination.
Context
StackExchange Database Administrators Q#5168, answer score: 2
Revisions (0)
No revisions yet.