Deploying DTS package in SQL Server 2000

One of the challenging activities in working with DTS packages in SQL server 2000 is deployment. Hard coding in DTS objects such as connections would appear inevitable and would require changes every time you deploy depending on the environment. Though Enterprise Manager provides extremely good UI to deploy, it is tedious to deploy using it when there are several packages. This article explains the process of removing hard coding with the help of parametrized global variables and also reading co...Full Article.