Export (0) Print
Expand All

Simple Transformation Sample Between Two SQL Server Tables

SQL Server 2000

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

© 2014 Microsoft