Update connection strings to use new provider names
Update the connection strings to use the SQL Server 2008 names for the following providers:
OLE DB Provider for Analysis Services
SQL Server Native Client
The SSIS Package Upgrade Wizard updates only connection strings that are stored in connection managers. The wizard does not update connection strings that are constructed dynamically by using the Integration Services expression language, or by using code in a Script task.
Validate upgrade packages
Validate the upgrade packages and save only those upgrade packages that pass validation.
If you do not select this option, the wizard will not validate upgrade packages. Therefore, the wizard will save all upgrade packages, regardless of whether the packages are valid or not. The wizard saves upgrade packages to the destination that is specified on the SelectDestination Location page of the wizard.
Validation adds time to the upgrade process. We recommend that you do not select this option for large packages that are likely to be upgraded successfully.
Create new package IDs
Create new package IDs for the upgrade packages.
Backup original packages
Have the wizard back up the original packages to an SSISBackupFolder folder. The wizard creates the SSISBackupFolder folder as a subfolder to the folder that contains the original packages and the upgraded packages.
This option is available only when you specify that the original packages and the upgraded packages are stored in the file system and in the same folder.