Data Transformation Services (DTS) is deprecated. You should plan to remove dependencies on DTS in anticipation of future releases of SQL Server. DTS itself will continue to be supported in SQL Server 2000, SQL Server 2005, and SQL Server 2008 as part of our ongoing commitment to provide support for those versions of SQL Server. However, the ability to migrate or run DTS packages might not be supported in the next release.

The DTS functionality that will be deprecated includes 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, and the Execute DTS 2000 Package task.

For information on 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 will be removed in the next release of SQL Server. Do not use this feature in the development of new packages. You should modify packages that currently use this feature as soon as possible. You can re-create the functionality of your ActiveX scripts by using the new control flow containers and the more flexible precedence constraints available in Integration Services. Or, you can rewrite your scripts by using the Integration Services Script task.

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

Concepts