Mssql 2005 Dts

[roger5089]

dear all

does any information i can reference to mssql 2005 to design my DTS .?
for example i can use this funtion in mssql 2000 but i do not know how? how can i start with DTS in mssql 2005

[umararif]

Well. DTS suffered criticism in SQL Server 2000 because the wizards weren't that good, and one also had 'to roll up ones sleeves' and start coding if attempting even something moderately unusual.

In SQL Server 2005, the DTS has been revised to improve the wizards and other front-end applications that use it, and the code has evidently had a great number of enhancements. However, I suspect that DTS is being kept only for backward-compatibility. This is because SSIS, which is a data-pump on steroids, (it is, correctly, an Extract-Transform-Load (ETL) tool) has been written from the ground up to take over most of the work that DTS was used for, leaving DTS to be primarily a tool to embed in scripting languages. However, the new Wizard applications are so good that DTS is going to get used and liked by a lot of people who don't need SSIS functionality.

check also http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/

DTS changed a lot in SQL Server 2005 and is now called Integration Services. From what I've seen, it's a bit more complicated to use, but I think importing and exporting data is still pretty straight forward. I don't think they changed that a whole lot, other than you have more control over the process to trap errors and that sort of thing. But honestly I can't tell you for sure, I'm just getting into using SQL 2005 myself on any kind of regular basis.

check following link for tutorial on that

http://msdn2.microsoft.com/en-us/library/ms169620.aspx