This Microsoft® Visual Basic® sample copies the Authors table from the pubs database to the pubs2 database while performing several operations on various fields. The sample is a single package with two connections, and two Steps/Tasks with multiple custom subtasks.
The comments in the source code of this sample provide detailed explanations of code that is generated by the Data Transformation Services (DTS) Import/Export Wizard.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Misc\Pub2Pubs
Running the Sample
- Create the pubs2 database that is a copy of the pubs database on the local server.
- Open the PubsToPub2.vbp project.
- Run the application.