I created the package in SQLServer import/export wizard, saving it as a .bas file. Then I added it to my VB project. Essentially, I have the identical table structure in two different SQL Server databases. The user only updates one of the tables. The VB program compares the table data and if different, calls the DTS package code to then copy one table to the other.

I wanted to add error handling in case the copy didn't complete or the power went out. Am looking for info on error handling in DTS.

Thanks for your help.