Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


SQL Server 2000

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

© 2015 Microsoft