Sample code for creating a simple transformation is located in the \Mssql\Devtools\Samples\Dts\Dtsexmp1 directory. A Transact-SQL script is used to create a sample table in the pubs database. The Microsoft® Visual Basic® sample then copies data from a source table to a destination table. Use these files:
To run this program, create an ODBC DSN for Microsoft SQL Server™ version 7.0 and make pubs the default database. Then run the Reattbl.sql script to create the authorname table.