Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining


SQL Server 2000

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

© 2015 Microsoft