How to: View Migrated DTS Packages

If you have used the Package Migration Wizard to migrate packages from Data Transformation Services (DTS) to Integration Services, you will probably want to view the migrated packages. You can view the migrated packages in either SQL Server Management Studio or Business Intelligence Development Studio. The following procedures describe how to use either studio to view packages.

Viewing Migrated DTS Packages in SQL Server Management Studio

The procedure for viewing migrated packages in Management Studio varies slightly based on whether you migrated the packages within Management Studio or Business Intelligence Development Studio.

To use Management Studio to view packages that you have migrated within Management Studio

  1. Open SQL Server Management Studio, if it is not already open.

  2. Connect to the local instance of Integration Services.

  3. In Object Explorer, expand the instance, and then expand the Stored Packages node.

    The next step depends on whether you chose SQL Server or the file system as the destination for the migrated packages.

  4. View the migrated packages by doing one of the following steps:

    • If you migrated the packages to SQL Server, select the MSDB node to view the migrated packages.

      —or—

    • If you migrated the packages to the file system, right-click the File System node and then select Import Package to view the migrated packages.

To use Management Studio to view packages that you have migrated within Business Intelligence Development Studio

  1. Open SQL Server Management Studio, if it is not already open.

  2. Connect to the local instance of Integration Services.

  3. In Object Explorer, expand the instance, and then expand the Stored Packages node.

    After you migrate packages from BI Development Studio, the migrated packages are saved to the file system folder that you specified. You have to import the packages to view them in Management Studio. The next step depends on whether you want to store the migrated packages in SQL Server or the file system.

  4. Import and view the migrated packages by doing one of the following steps:

    • If you migrated the packages to SQL Server, right-click the MSDB node, and then select Import package to import and view the migrated packages.

      —or—

    • If you migrated the packages to the file system, right-click the File System node and then select Import package to import and view the migrated packages.

Viewing Migrated DTS Packages in Business Intelligence Development Studio

The procedure for viewing migrated packages in Business Intelligence Development Studio varies based on whether you migrated the packages within Business Intelligence Development Studio or Management Studio.

To use Business Intelligence Development Studio to view packages that you have migrated within Business Intelligence Development

  1. Open Business Intelligence Development Studio, if it is not already open.

    After you migrate packages from BI Development Studio, the migrated packages are saved to the file system folder that you specified and added to the open project under the SSIS Packages node.

  2. Reopen the Integration Services project that contains the migrated packages, if it is not already open.

To use Business Intelligence Development Studio to view packages that you have migrated within Management Studio

  1. Open Business Intelligence Development Studio, if it is not already open.

  2. Create a new Integration Services project, or open an existing project, to serve as a container for the migrated packages.

  3. In Solution Explorer, right-click the SSIS Packages node, and then select Add Existing Package.

    The next step depends on whether you chose SQL Server or the file system as the destination for the migrated packages.

  4. View the migrated packages by doing one of the following procedures:

    To view the packages that you migrated to SQL Server

    1. In the Add Copy of Existing Package dialog box, for Package location, select SQL Server.

    2. Fill in the authentication information, and click the Browse button (...).

    3. In the SSIS Package dialog box, select the package that you want to add to the open project.

    4. Click OK two times to return to BI Development Studio.

    To view the packages that you migrated to the file system

    1. In the Add Copy of Existing Package dialog box, for Package location, select File system.

    2. Click the Browse button (...).

    3. In the Load Package dialog box, find and select the package that you want to add to the open project.

    4. Click Open, and then click OK to return to BI Development Studio.