Dela via


How to: Migrate Data Transformation Services Packages to Integration Services

You are not required to migrate SQL Server 2000 Data Transformation Services (DTS) packages to the Integration Services package format. DTS packages can continue to run alongside Integration Services packages.

Note

For information on upgrading packages that were created in an earlier version of Integration Services, see Upgrading Integration Services Packages.

If you want to migrate your DTS packages, SQL Server provides the DTS Package Migration Wizard to help in this process. Because the wizard leaves your original packages intact, you can always continue to use the original packages if you experience migration difficulties.

The Package Migration Wizard is installed when Integration Services is installed. For more information, see How to: Install Support for Data Transformation Services Packages.

Note

The Package Migration Wizard is available in the Standard, Enterprise, and Developer Editions of SQL Server.

For more information about migrating DTS packages, see Migrating Data Transformation Services Packages.

For more information about the upgrade and migration options available to users of Data Transformation Services, see Considerations for Upgrading Data Transformation Services.

For general information about support for DTS in Integration Services, see Support for SQL Server 2000 DTS in SQL Server 2008 R2.

To migrate Data Transformation Services packages to Integration Services

  1. Optionally, run the Upgrade Advisor to analyze your existing packages and obtain a report of potential migration issues. For more information, see Known DTS Package Migration Issues.

  2. Run the Package Migration Wizard to migrate your packages.

  3. Reconfigure the package items that must be manually reconfigured as reported by the Upgrade Advisor or the wizard.

  4. Test and troubleshoot the migrated packages as needed.

    For information about how to view migrated packages in Business Intelligence Development Studio or SQL Server Management Studio, see How to: View Migrated DTS Packages.