Chapter 10. 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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
