DataPumpTransformTrimString Object

DTS Programming

DTS Programming

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
LowerCaseString Property TrimTrailingWhiteSpace Property
TrimEmbeddedWhiteSpace Property UpperCaseString Property
TrimLeadingWhiteSpace Property  
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

Adding DTS Column Objects

Adding DTS Transformations

DataDrivenQueryTask2 Object

DataPumpTask2 Object

DataPumpTransformLowerString Object

DataPumpTransformMidString Object

DataPumpTransformUpperString Object

New (ID) Method

Transformation2 Object

Transformations Collection

TransformationSet Object

TransformFlags Property

TransformServer Property