How to: Migrate Data Transformation Services Packages to Integration Services

SQL Server Setup

previous page next page

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

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

If you want to migrate your DTS packages, SQL Server 2005 provides the 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: Ensure Support for Data Transformation Services Packages.

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

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

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

See Also

previous page start next page