Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: SQL Server DTS Best Practices

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2003-05-27 : 10:10:33
Narayana Vyas Kondreddi submitted "This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources."

Article Link.


12543 Posts

Posted - 2003-05-27 : 11:29:05
Misses the most important point.
Only use dts when it's applicable. Don't assume that just because you are doing an import that it should be controlled by dts.

Only looked at the performance bit. That almost says don't use dts in places but unfortunately doesn't suggest the option.

Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2003-05-27 : 14:37:30
LOL...I see your point. But I'll add that to 'SQL Server programming best practices'. I do agree that, people tend to implement everything in DTS, which the can be done with a simple scheduled script.

Go to Top of Page

- Advertisement -