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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
