• Article

Select Package Management Options (SSIS Package Upgrade Wizard)

Use the Select Package Management Options page to specify options for upgrading packages.

To run the SSIS Package Upgrade Wizard

Options

  • 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.

    Note

    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.

    For more information, see How to: Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard.

  • Continue upgrade process when a package upgrade fails
    Specify that when a package cannot be upgraded, the SSIS Package Upgrade Wizard continues to upgrade the remaining packages.

  • Package name conflicts
    Specify how the wizard should handle packages that have the same name. This option has the values listed in the following table.

    • Overwrite existing package files
      Replaces the existing package with the upgrade package of the same name.

    • Add numeric suffixes to upgrade package names
      Adds a numeric suffix to the name of the upgrade package.

    • Do not upgrade packages
      Stops the packages from being upgraded and displays an error when you complete the wizard.

    These options are not available when you select the Save to source location option on the Select Destination Location page of the wizard.