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: