Export (0) Print
Expand All

Complex Transformation Sample from SQL Server to Excel

SQL Server 2000

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

© 2015 Microsoft