DTS Programming
Simple Transformation Sample Between Two SQL Server Tables
This Microsoft® Visual Basic® sample copies data from a source table to a destination table, after a Transact-SQL script is used to create a sample table in the pubs database.
Default Location
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtspackages\Dtsexmp1
Running the Sample
Here are the steps for running the Dtsexmp1 application:
- Create an ODBC DSN for Microsoft SQL Server™ and make pubs the default database.
- Run the Creattbl.sql script to create the authorname table.
- Open and run Dtsexmp1.vbp.