Pub2Pubs

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.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Misc\Pub2Pubs

Running the Sample

1. Create the pubs2 database that is a copy of the pubs database on the local server.
   
   
2. Open the PubsToPub2.vbp project.
   
   
3. Run the application.

See Also

DTS Programming Samples