DTSCopy

This Microsoft® Visual C++® sample creates and registers a simple custom transformation. It copies a single source column of any simple type into a destination column of the same type.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\CustomTransforms\DTSCopy

Running the Sample

1. In the Visual C++ development environment, open and run DTSXForm.dsw.
   
   
2. On the Build menu, click Build DTSXForm.dll to build the project.
   
   
3. In Microsoft SQL Server™ Enterprise Manager, right-click Data Transformation Services, click Properties, and then click Refresh Cache, if caching is active.
   
   
4. Include the custom transformation in a Transform Data task in DTS Designer.

For more information about how this example is implemented, see DTS Custom Transformation Example: Copy One Column.

See Also

Implementing and Testing a DTS Custom Transformation

DTS Programming Samples