As an alternative to using SQL Server Enterprise Manager, you can use the DTS COM interface to create and execute packages. One advantage of using the DTS COM interface is that you can create custom applications (using Microsoft® Visual Basic®, C++, Visual Basic Scripting Edition, or Microsoft JScript®) that allow you to extend the capabilities of DTS by defining customized transformations using DTS package, DTS scripting objects, and DTS Data Pump interfaces.
The DTS API is designed to maximize the extensibility of DTS by allowing the addition of connections, tasks, and objects to a package. The Package object has collections for Connection, Task, and Step objects. New objects can easily be added to these collections to extend the processing performed by the package.
| Programming DTS Applications | DTS Reference |