Migrating SQL Server 2000 Data Transformation Services (DTS) Packages to SQL Server 2012
Published Mar 25 2019 03:33 PM 1,918 Views
Not applicable
First published on MSDN on May 04, 2012

SQL Server Integration Services (SSIS) 2012 doesn't support migrating or running DTS packages.  You do have the following options for migrating your DTS packages to SSIS 2012.

  • Recreate the SQL Server 2000 Integration Services packages by using SSIS 2012. The What's New in Books Online provides an overview of the new features in SSIS 2012. The Integration Services (SSIS) Packages topic describes the elements of an SSIS package.

Here is a list of the DTS functionality that has been discontinued in SSIS 2012.

  • DTS runtime


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

  • Support for DTS package maintenance in SQL Server Management Studio

  • Execute DTS 2000 Package task

  • Upgrade Advisor scan of DTS packages.

Version history
Last update:
‎Mar 25 2019 03:33 PM
Updated by: