This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL Server 2012 SSIS. I’m very impressed at the much-improved capabilities for deploying SSIS packages in a less-scary way using package and project parameters, support for SSIS “environments” (“prod”, “dev”, “test”, etc.) and several other improvements including SQL Server 2012 automatically archiving previous versions of your packages when a new version is deployed. It seems that it may actually be practical to use the built-in SSIS deployment functionality now.
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI329
This presentation was delivered by Sven Aelterman at TechEd 2012 – well done Sven!
