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."
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.
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.
Article: SQL Server DTS Best Practices
Posted - 05/27/2003 : 10:10:33
