Complex Transformation from SQL Server to Excel

Sample code for creating a complex transformation is located in the \Mssql7\DevTools\Samples\Dts\Dtsexmp2 directory. This program copies data from the pubs database to a Microsoft® Excel spreadsheet, transforming it into a PivotTable®. The program also demonstrates how to create a DTS COM object. Use these files:

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.