Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Chapter 7

Upgrading Packages to SQL Server 2012

With every new version of Integration Services, there is a path you must follow to upgrade your existing solution to the latest version of the tool. In SQL Server 2012, you can upgrade your 2005 or 2008 SSIS package using the SSIS Package Upgrade Wizard.

The SSIS Package Upgrade Wizard fully upgrades your packages, but you should note a few things upon the completion of the upgrade. The wizard automatically updates connection strings that use an outdated data provider to the latest drivers that come natively with SQL Server. This is a nice feature, but if the packages you are upgrading use configurations to overwrite data source information, as described in Section 7 of this book, you must manually upgrade the providers in the configurations; this wizard, by default, does not upgrade configuration values.

The wizard also does not upgrade packages to utilize many of the new features available in SSIS 2012. For example, it does not upgrade Execute Package Tasks to use the new internal project reference. Also, after converting, the wizard leaves your packages set to the old package deployment model. New packages that are developed in SSIS use the project deployment model, which is detailed in Lesson 8.

You can invoke the SSIS Package Upgrade Wizard by simply opening your packages in SQL Server Data Tools (SSDT) or you can upgrade your packages manually by running SSISUpgrade.exe, the SSIS Package Upgrade Wizard executable (Figure 7-1 ...