DTS Custom Transformation Sample

DTS Programming

DTS Programming

DTS Custom Transformation Sample

This Microsoft® Visual C++® sample creates and registers a custom transformation. It concatenates a number of ANSI string source columns into a single destination column.

Default Location

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

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.

If you are compiling the example transform for use under Microsoft Windows® 98, be sure you compile using a non-UNICODE configuration. To set the configuration, use the Set Active Configuration option on the Build menu.

See Also

Implementing and Testing a DTS Custom Transformation

DTS Programming Samples