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