SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 DTS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

X002548
Not Just a Number

15586 Posts

Posted - 11/22/2004 :  15:08:50  Show Profile  Reply with Quote
Not that DTS comes with Express, but from bol...

Not that it'sgoing to tempt me to start using it for anything other than a simple import...but it's interesting to see M$ slam their own product..

So...if anyone thought DTS was/is painful....rejoice....M$ thinks so too

quote:

Previous versions of Microsoft SQL Server Data Transformation Services (DTS) provided only a basic set of tasks and transformations, making it difficult to construct packages with complex and repeating workflows, and to apply different types of column-level transformations to data. Also, the graphical tool used to create packages combined the workflow and data flow offering limited control flow semantics.

In Microsoft SQL Server 2005, Microsoft redesigned DTS from the ground up, thereby solving the difficulties of these previous versions. DTS enhancements include a new extensible architecture, a new DTS Designer, a multitude of new tasks, looping structures, and transformations, as well as improvements of package management and deployment.






Brett

8-)

euan_garden
Microsoft SQL Server Product Team

34 Posts

Posted - 11/28/2004 :  22:52:12  Show Profile  Reply with Quote
You and I obviously have different definitions of slam. I see this as a recognition of the feedback on the limitations of the current product. That same feedback was used to drive higher investment in the DTS product in SQL2005 to the level at which we felt it was right to rename it.

-Euan

Euan Garden
Product Unit Manager
SQL Server Tools
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000