DTSTransferObjectsTask

This Microsoft® Visual Basic® sample demonstrates how to use Data Transformation Services (DTS) to transfer various types of database objects from the pubs database to the pubs2 database.

The objects transfered in this sample are:

• Authors table.
  
  
• Employee table.
  
  
• Titleview view.
  
  
• Byroyalty stored procedure.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasls\DTSTransferObjectsTask

Running the Sample

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

See Also

DTS Programming Samples