How to: Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard

SQL Server Setup

You can upgrade packages that were created in earlier versions of Integration Services to the Integration Services format that SQL Server 2008 uses. SQL Server provides the SSIS Package Upgrade Wizard to help in this process. Because you can configure the wizard to backup up your original packages, you can continue to use the original packages if you experience upgrade difficulties.

The SSIS Package Upgrade Wizard is installed when Integration Services is installed.

Note:
The SSIS Package Upgrade Wizard is available in the Standard, Enterprise, and Developer Editions of SQL Server.

For more information about how to upgrade Integration Services packages, see Upgrading Integration Services Packages.

Note:
For information about migrating packages that were created in SQL Server 2000 Data Transformation Services (DTS), see Migrating Data Transformation Services Packages.

The remainder of this topic describes how to run the wizard and back up the original packages.

Running the SSIS Package Upgrade Wizard

You can run the SSIS Package Upgrade Wizard from Business Intelligence Development Studio, from SQL Server Management Studio, or at the command prompt.

To run the wizard from Business Intelligence Development Studio

  1. In Business Intelligence Development Studio, create or open an Integration Services project.

  2. In Solution Explorer, right-click the SSIS Packages node, and then click Upgrade All Packages to upgrade all the packages under this node.

    Note:
    When you open an Integration Services project that contains SQL Server 2005 Integration Services (SSIS) packages, Integration Services automatically opens the SSIS Package Upgrade Wizard.

To run the wizard from SQL Server Management Studio

  • In SQL Server Management Studio, connect to Integration Services, expand the Stored Packages node, and right-click the File System or MSDB node, and then click Upgrade Packages.

To run the wizard at the command prompt

  • At the command prompt, run the SSISUpgrade.exe file from the C:\Program Files\Microsoft SQL Server\100\DTS\Binn folder.

Backing Up the Original Packages

To back up the original packages, both the original packages and the upgraded packages must be stored in the same folder in the file system. Depending on how you run the wizard, this storage location might be automatically selected:

  • When you run the SSIS Package Upgrade Wizard from Business Intelligence Development Studio, the wizard automatically stores both the original packages and upgraded packages in the same folder in the file system. You can configure the wizard to back up the original packages.
  • When you run the SSIS Package Upgrade Wizard from SQL Server Management Studio or at the command prompt, you can specify different storage locations for the original and upgraded packages. To back up the original packages, make sure to specify that both the original and upgraded packages are stored in the same folder in the file system. If you specify any other storage options, the wizard will not be able to back up the original packages.

When the wizard backs up the original packages, the wizard stores a copy of the original packages in an SSISBackupFolder folder. The wizard creates this SSISBackupFolder folder as a subfolder to the folder that contains the original packages and the upgraded packages.

To back up the original packages in SQL Server Management Studio or at the command prompt

  1. Save the original packages to a location on the file system.

    Note:
    The backup option in the wizard only works with packages that have been stored to the file system.

  2. In SQL Server Management Studio or at the command prompt, run the SSIS Package Upgrade Wizard.

  3. On the Select Source Location page of the wizard, set the Package source property to File System.

  4. On the Select Destination Location page of the wizard, select Save to source location to save the upgraded packages to the same location as the original packages.

    Note:
    The backup option in the wizard is available only when the upgraded packages are stored in the same folder as the original packages.

  5. On the Select Package Management Options page of the wizard, select the Backup original packages option.

To back up the original packages in Business Intelligence Development Studio

  1. Save the original packages to a location on the file system.

    Note:
    The backup option in the wizard only works with packages that have been stored to the file system.

  2. In Business Intelligence Development Studio, run the SSIS Package Upgrade Wizard.

  3. On the Select Package Management Options page of the wizard, select the Backup original packages option.