Chapter 10. Interacting with a Package Using Visual Basic

Interacting with a Package Using Visual Basic

In Chapter 9, “Building a Package Using Visual Basic,” you saw that in some situations the DTS Designer might not be the best tool to implement your solution. You then created a VB program that used the DTS object model to transform and load data into a SQL database. In this chapter, you will build on this knowledge and investigate some best practices. You will learn about the following:[1]

  • Executing DTS packages from Visual Basic

  • Making best-practice modifications to DTS VB .bas files

  • Loading and saving packages

  • Event Handling

  • Error Handling

Armed with this knowledge, we will investigate DTS ...

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.