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.