DTSStrings

This Microsoft® Visual C++® sample creates and registers a custom transformation. It reformats two source columns that are assumed to be a first and last name into the form of Last, First in a single destination column. The source and destination columns can be ANSI or wide-character strings. Conversion between ANSI and wide characters is performed, as necessary.

Default Location

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

Running the Sample

1. In the Visual C++ development environment, open and run DTSStrings.dsw.
   
   
2. On the Build menu, click Build DTSStrings.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: Format Names.

See Also

Implementing and Testing a DTS Custom Transformation

DTS Programming Samples