This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections such as DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.

This story continues at http://databasejournal.com/news/article.php/2212911