Helpful information and examples on how to use SQL Server Integration Services.
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.
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.
Thanks a lot for your Tips, I am about to migrate my DTS packages to SQL Server 2012, So If i don’t have SQL Server 2005 or SQl Server 2008 what are my options ?
I will appreciate your help
Many thanks
Syed
You may want to check with the Pragmatic Works about using DTS xChange to migrate your DTS packages.
How about ActiveX?. Can one migrate DTS Packages with ActiveX scripts from SQL 2000 to SQL 2012 automatically or manually the only way to accomplish this?
Thank you very much for this information. We are currently testing SQL 2012 in our development environment. DTS is on the list of subjects, and this will help us a lot with our decision making.