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

Transformation Objects

SQL Server 2000

This section describes the Data Transformation Services (DTS) transformation classes supplied with Microsoft® SQL Server™ 2000.

Topic Description
DataPumpTransformCopy Object Copies multiple source columns to destination columns.
DataPumpTransformDateTimeString Object Converts datetime string formats.
DataPumpTransformLowerString Object Converts multiple source columns to lowercase characters and copies them to destination columns.
DataPumpTransformMidString Object Extracts substrings from a source column; optionally trims white space and changes case.
DataPumpTransformReadFile Object Copies data read from files into destination columns.
DataPumpTransformScript Object Transforms data with user-supplied Microsoft ActiveX® scripts.
DataPumpTransformTrimString Object Removes white-space characters from data and optionally changes case.
DataPumpTransformUpperString Object Converts multiple source columns to uppercase characters and copies them to destination columns.
DataPumpTransformWriteFile Object Writes data from a source column into files.
DTSTransformScriptProperties2 Object Supports multiphase transformations with an extended DataPumpTransformScript object.

© 2015 Microsoft