DTS Programming
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
- Create the pubs2 database that is a copy of the pubs database on the local server.
- Open the DTSTransferObjectsTask.vbp project.
- Run the application.