SQL Server DTS

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 ...