Chapter 9. Building a Package Using Visual Basic

In Chapter 2, “DTS—An Overview,” we used DTS Designer to create a sample DTS package. DTS Designer, a simple yet effective tool, provides a graphic interface for manipulating the underlying DTS object model. Although providing ample functionality for most applications, it does not expose all objects, properties, and methods of the model. As a result, it is not the best mechanism for certain situations, such as the following:
Standalone applications or servers
GUI applications in which you want to interact with users and allow them to control or monitor DTS progress
Automated processing, such as:
Processing ...
Get SQL Server DTS now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.