4

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?

1 Answer 1

6

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.

1
  • Hi Matt! Welcome to our site, we're really glad you're here. If you don't feel shy, you can pass and say hello on The Heap, too.
    – Marian
    Commented May 20, 2013 at 20:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.