Data Transformation Services (DTS)


For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.

Data Transformation Services (DTS) has been replaced by SQL Server Integration Services.

SQL Server 2008 Setup does not install DTS support. For more information about DTS functionality in SQL Server 2008, see Support for SQL Server 2000 DTS in SQL Server 2008 R2. For information about how to install DTS functionality, see How to: Install Support for Data Transformation Services Packages.

Data Transformation Services Is Deprecated

Data Transformation Services (DTS) is deprecated. You should plan to remove dependencies on DTS in anticipation of future releases of SQL Server. Although SQL Server 2005 and SQL Server 2008 still include DTS functionality, the ability to migrate or run DTS packages might not be supported in the next release.

The following DTS functionality has been deprecated:

  • The DTS runtime.

  • The DTS API.

  • The Package Migration Wizard for migrating DTS packages to the next version of Integration Services.

  • Support for DTS package maintenance in SQL Server Management Studio.

  • The Execute DTS 2000 Package task.

For information about how to migrate DTS packages to the Integration Services package format, see Migrating Data Transformation Services Packages.

The ActiveX Script task in SQL Server 2008 is provided only for backward compatibility with DTS and is also deprecated. Do not use this feature in developing new packages. You should modify packages that currently use this feature as soon as possible. To re-create the functionality of your ActiveX scripts, use the new control flow containers and the more flexible precedence constraints that are available in Integration Services. Or, use the Script task in Integration Services to rewrite your scripts.

For information about how to migrate scripts, see Migrating Scripts.