O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required