THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Rick Heiges

News about SQL Server and the SQL Server Community

DTS still alive in 2008?

I was on a call with several other folks the other day discussing "Katmai".  The topic of DTS came up. MSFT had indicated that support for DTS would not go beyond SQL Server 2005 in a variety of channels.  I can remember the dozens of Upgrade Advisor messages that always appeared.  I just revisited the "Advisory" text.  It says that support for DTS will be discontinued at a future date. 

Well, it looks like a bunch of folks out there still love those DTS packages.  Why do I say this?  In the July CTP of SQL Server 2008 BOL, there is a section on DTS.  Basically, there is nothing different about DTS support for 2008.

No News is Good News?  Yes and No.  Yes - that means that many organizationis will not be forced to rewrite DTS packages into SSIS as they move forward.  No - that means that many organizations will not take advantage of newer technology.

Also, no SSIS in Express edition in 2008. BOL still recommends using 2000 DTS components here.


Published Wednesday, August 22, 2007 6:55 AM by RickHeiges
Filed under: , , , ,

Comments

 

Denise Draper said:

Hi Rick --- You've got the story pretty much correct, and I feel the same way about DTS as you do :-)  But we heard loud and clear that there were too many customers who couldn't simply move their DTS packages.

One point I want to clarify --- SSIS will not be in SQL Express 2008, but the Import/Export wizard will be.  We hope the wizard will cover a lot of the needs of Express users, without requireing SSIS.   The BOL probably needs to be updated to call that out.

denise (Product Unit Manager of the SSIS team)

August 22, 2007 8:06 PM
Anonymous comments are disabled
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement