Why The Tutorial?
One of the ways to gain a lot of Flexibility in DTS is to use an ActiveX script. They can be found in the transform Data Task, the Data Driven Query Task and as a standalone task. When we look at the actual screens there is a lot to see and some of the things can be daunting especially if you have no programming experience. We'll walk through them and explain the uses of each item. The interface has changed a lot between versions 7 and 2000 of SQL Server so we shall break this tutorial into two and cover a version in each half. The 2000 version is greatly improved from the 7 version and hopefully Microsoft will carry this onto into the next release.