Export (0) Print
Expand All

How to: Upgrade from Data Transformation Services to Integration Services

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 SQL Server 2000 DTS in SQL Server 2008 R2.

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.


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 R2 (Setup).

To upgrade from Data Transformation Services to Integration Services

  • Run SQL Server 2008 Setup, and then select Upgrade from SQL Server 2000 or SQL Server 2005.


  • At the command prompt, run setup.exe and specify the /ACTION=upgrade option.

    For more information about how to install at the command prompt, see the section, "Installation Scripts for Integration Services," in How to: Install SQL Server 2008 R2 from the Command Prompt.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft