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:
Executing DTS packages from Visual Basic
Making best-practice modifications to DTS VB .bas files
Loading and saving packages
Armed with this knowledge, we will investigate DTS ...