The following procedure describes how to use Setup to upgrade an installation of SQL Server 2000 Data Transformation Services (DTS) to Integration Services. For more information, see Considerations for Upgrading Data Transformation Services.

SQL Server 2008 does not install run-time support for DTS packages. You have to install this run-time support before you can run DTS packages. For information about how to install support for DTS, see How to: Install Support for Data Transformation Services Packages. For more detailed information about support for DTS in SQL Server 2008, see Support for Data Transformation Services (DTS) in SQL Server 2008.

After upgrading, you can optionally use the DTS Package Migration Wizard to migrate DTS packages to the Integration Services format. During migration, the wizard copies DTS packages and then re-creates them in the Integration Services format. The source packages are left intact and are not modified. For more information, see Migrating Data Transformation Services Packages.

Note:
The DTS Package Migration Wizard is available in the following editions of SQL Server: Standard, Enterprise, and Developer.

For more information about how to upgrade, see How to: Upgrade to SQL Server 2008 (Setup).

To upgrade from Data Transformation Services to Integration Services

See Also