THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
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: , , , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



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

Leave a Comment


This Blog


Privacy Statement