posted 11/11/2010 by DevinKnight - Views: [3593]
The end has come! We've been told for several years the vNext of SQL Server will no longer support DTS and it appear that that time has come. Taking a look at the CTP of SQL Server Denali one of the first things I noticed is that you no longer see Data Transformation Services under the legacy section of the Database Engine.
So it appears that your hand may be forced to convert!
I'll make this note too. When you connect to an older version of SQL Server (2008 R2 in my case) inside Denali then it still does not show the DTS section.
Check out other dead features in Denali here. http://technet.microsoft.com/en-us/library/bb500429(SQL.110).aspx
Thanks for posting this which helps all of us to gain knowledge about new technologies.
Now, the question start with what is the best tool to convert DTS to SSIS? and is it self migration with sql server or third party tool.
I use DTSxChange. Pragmatic Works makes it. Picks up a lot of the things the Microsoft wizard leaves behind http://www.pragmaticworks.com/Products/Business-Intelligence/DTSxChange/Default.aspx.