DTS Programming
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
- In the Visual C++ development environment, open and run DTSXForm.dsw.
- On the Build menu, click Build DTSXForm.dll to build the project.
- In Microsoft SQL Server™ Enterprise Manager, right-click Data Transformation Services, click Properties, and then click Refresh Cache, if caching is active.
- 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.