Chapter 9. Building a Package Using Visual Basic

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.