Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 4 down vote accepted

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.

share|improve this answer
    
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 May 20 '13 at 20:08
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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