snippetsqlMinor
Convert SQL Server 2012 SSIS package to 2008
Viewed 0 times
2012package2008convertsqlssisserver
Problem
I've created a few SSIS packages in SQL Server 2012 that I need to run on SQL Server 2008. I've been told that it is impossible in their current state.
Is there a way to convert the 2012 packages to a 2008 version?
If not, what are my alternatives? Start over?
Is there a way to convert the 2012 packages to a 2008 version?
If not, what are my alternatives? Start over?
Solution
Yes, you'll need to recreate the package in 2008. 2005/2008 packages can be upgraded to 2012, but downgrading doesn't work.
There is a codeplex project/utility that can move 2008 packages to 2005 by changing version numbers, and making small changes to the XML. Unfortunately this approach doesn't work with 2012, as the package format went through some big changes.
There is a codeplex project/utility that can move 2008 packages to 2005 by changing version numbers, and making small changes to the XML. Unfortunately this approach doesn't work with 2012, as the package format went through some big changes.
Context
StackExchange Database Administrators Q#42641, answer score: 6
Revisions (0)
No revisions yet.