Complex Transformation Sample from SQL Server to Excel

This program copies data from the pubs database to a Microsoft® Excel spreadsheet, transforming it into a Microsoft PivotTable®. The program also demonstrates how to create a Data Transformation Services (DTS) object.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtspackages\Dtsexmp2

Running the Sample

Here are the steps for running the Cptexmp application:

1. Open and compile Cptaxdll.vbp.

   This registers the CreatePivotTable custom task used by Cptexmp.vbp and tstuiapp.vbp.

2. Open and run Cptexmp.vbp or tstuiapp.vbp.

See Also

DTS Programming Samples