Home
%3CLINGO-SUB%20id%3D%22lingo-sub-388082%22%20slang%3D%22en-US%22%3EMigrating%20SQL%20Server%202000%20Data%20Transformation%20Services%20(DTS)%20Packages%20to%20SQL%20Server%202012%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388082%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20May%2004%2C%202012%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3ESQL%20Server%20Integration%20Services%20(SSIS)%26nbsp%3B2012%26nbsp%3Bdoesn't%20support%20migrating%20or%20running%20DTS%20packages.%26nbsp%3B%20You%20do%20have%20the%20following%20options%20for%20migrating%20your%26nbsp%3BDTS%20packages%20to%20SSIS%202012.%3C%2FP%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EMigrate%20the%20packages%20to%20SSIS%202005%26nbsp%3Bor%20SSIS%202008%2C%20and%20then%20upgrade%20the%20packages%26nbsp%3Bto%20SSIS%202012.%20For%20information%20about%20migrating%20packages%20to%202005%20or%202008%2C%20see%20%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms143501(SQL.90).aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Migrating%20Data%20Transformation%20Services%20Packages%20%3C%2FA%3E%20(2005)%20and%20%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms143501(SQL.100).aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Migrating%20Data%20Transformation%20Services%20Packages%20%3C%2FA%3E%20(2008)%20in%20Books%20Online.%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3ERecreate%20the%20SQL%20Server%202000%20Integration%20Services%20packages%20by%20using%20SSIS%202012.%20The%20%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fbb522534.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20What's%20New%20%3C%2FA%3E%20in%20Books%20Online%26nbsp%3Bprovides%20an%20overview%20of%20the%20new%20features%20in%20SSIS%202012.%20The%20%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms141134.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Integration%20Services%20(SSIS)%20Packages%20%3C%2FA%3E%20topic%20describes%20the%20elements%20of%20an%20SSIS%20package.%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EHere%20is%20a%20list%20of%20the%20DTS%20functionality%20that%20has%20been%20discontinued%20in%20SSIS%202012.%3C%2FP%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3CP%3EDTS%20runtime%3C%2FP%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3CP%3EDTS%20API%3C%2FP%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3CP%3EPackage%20Migration%20Wizard%20for%20migrating%20DTS%20packages%20to%20the%20next%20version%20of%20%3CBR%20%2F%3E%20Integration%20Services%3C%2FP%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3CP%3ESupport%20for%20DTS%20package%20maintenance%20in%20SQL%20Server%20Management%20Studio%3C%2FP%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3CP%3EExecute%20DTS%202000%20Package%20task%3C%2FP%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3CP%3EUpgrade%20Advisor%20scan%20of%20DTS%20packages.%3C%2FP%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-388082%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20May%2004%2C%202012%20SQL%20Server%20Integration%20Services%20(SSIS)%26nbsp%3B2012%26nbsp%3Bdoesn't%20support%20migrating%20or%20running%20DTS%20packages.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388082%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Esql2012%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Essis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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




  • 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.