DTS Programming
Transformation Objects
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. |