Migrating SQL Server 2000 Data Transformation Services (DTS) Packages to SQL Server 2012

[SSIS-Team]

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.

• Migrate the packages to SSIS 2005 or SSIS 2008, and then upgrade the packages to SSIS 2012. For information about migrating packages to 2005 or 2008, see Migrating Data Transformation Services Packages (2005) and Migrating Data Transformation Services Packages (2008) in Books Online.

• 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

  
  


• 
  

  DTS API

  
  


• 
  

  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.