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 Data Transformation Services (DTS) in SQL Server 2008.

To migrate Data Transformation Services packages to Integration Services

See Also