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:

1. Create an ODBC DSN for Microsoft SQL Server™ and make pubs the default database.
   
   
2. Run the Creattbl.sql script to create the authorname table.
   
   
3. Open and run Dtsexmp1.vbp.

See Also

DTS Programming Samples