DataPumpTransformTrimString Object
The DataPumpTransformTrimString object converts the source column to uppercase or lowercase characters, as specified by the UpperCaseString and LowerCaseString properties. It trims white-space characters, as specified by the TrimLeadingWhiteSpace, TrimTrailingWhiteSpace and TrimEmbeddedWhiteSpace properties. It converts, if necessary, to the destination column data type. It requires one source column and one destination column, both of a string data type (char, varchar, text, nchar, nvarchar, ntext, and flat file strings).
Destination truncation is possible by setting DTSTransformFlag_AllowStringTruncation in the TransformFlags property of the Transformation object.
Properties
Remarks
The DataPumpTransformMidString object also performs case changing and white space removal functions. If only case conversion is required, the DataPumpTransformLowerString or DataPumpTransformUpperString objects can be used. These transformations accept multiple source and destination columns.
The New method of the Transformations collection of the DataPumpTask, DataDrivenQueryTask, and TransformationSet objects returns a reference to a Transformation2 object. The TransformServer property of the Transformation2 object returns a reference to the appropriate custom transformation object.
See Also
DataPumpTransformLowerString Object
DataPumpTransformMidString Object