• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

SSIS: Converting from 2012 to 2008

I created a couple of SSIS package using on 2012 version of Sql Server (and Visual Studio).
I'd like to run them in Sql Server 2008 (and Visual Studio) environment.
Packages are not complex.

What are my choices?
Thanks.
0
quasar_ee
Asked:
quasar_ee
1 Solution
 
Jerry MillerCommented:
I know that you can upgrade from 2008 to 2012, I don't know of a way to downgrade a package. I would create a new SSIS package in Visual Studio and copy the functionality into a 2008 package. If they aren't too complex it doesn't take much time.

Most of the steps can be copy / pasted into the new solution, but there may be some things that you won't be able to do that way.

I had a lot of 2005 packages that generated errors when trying to convert to 2008 and then to 2012, so I had to recreate all of them. It was a pain, but I was able to add some additional functionality in the process so it was not a total loss.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now