Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Running SSIS 2005 Packages on SQL 2012 Instance Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 2:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:39 AM
Points: 1, Visits: 4
Hi all--

We are going through the process of rationalizing our databases from SQL Server 2005 to 2012. In our development environment, however, we have many packages in SSIS 2005.

We plan on upgrading all of the packages from SSIS 2005 to SSIS 2012, but given the volume of packages necessary and certain standards we have to abide by when testing and deploying packages, it will take some time. (must be upgraded on local, then deployed to dev, then staging...)

My question is this: If I upgrade the engine and databases from SQL Server 2005 to SQL Server 2012, will my SSIS 2005 packages still execute properly with the SQL Server 2012 engine until we upgrade all of the SSIS packages from 2005 to 2012? Are there any caveats I should be aware of?

Thanks in advance!
Post #1450806
Posted Wednesday, May 8, 2013 6:44 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 8, 2014 4:15 PM
Points: 727, Visits: 1,417
atalders (5/8/2013)
Hi all--

We are going through the process of rationalizing our databases from SQL Server 2005 to 2012. In our development environment, however, we have many packages in SSIS 2005.

We plan on upgrading all of the packages from SSIS 2005 to SSIS 2012, but given the volume of packages necessary and certain standards we have to abide by when testing and deploying packages, it will take some time. (must be upgraded on local, then deployed to dev, then staging...)

My question is this: If I upgrade the engine and databases from SQL Server 2005 to SQL Server 2012, will my SSIS 2005 packages still execute properly with the SQL Server 2012 engine until we upgrade all of the SSIS packages from 2005 to 2012? Are there any caveats I should be aware of?

Thanks in advance!


There are some pretty large changes to the way SSIS is managed in 2012. First and foremost is that SSIS is no longer a separate server, but part of the sql service. Additionally, I believe (and check this) that they changed the configuration files. As such, my understanding has always been that different versions SSIS don't run on anything the SQL Server version they were built on, and this would be especially true going from 2005 to 2012.

However, the best thing to do is to try it. You never know. Might just depend upon the complexity of the package and the tasks that are being used.

Fraggle

Post #1450856
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse