DataPumpTransformUpperString Object
The DataPumpTransformUpperString object converts a source column to uppercase characters and, if necessary, to the destination column data type. It requires source and destination columns to be of string data types (char, varchar, text, nchar, nvarchar, ntext, and flat file strings). Like the DataPumpTransformCopy object, this transformation object supports multiple source and destination columns. Destination truncation is possible by setting DTSTransformFlag_AllowStringTruncation in the TransformFlags property of the Transformation2 object. There are no custom transformation properties.
Remarks
Conversion to uppercase characters is also a feature of the DataPumpTransformTrimString and DataPumpTransformMidString objects.
For more information, see DataPumpTransformLowerString Object. The DataPumpTransformUpperString object is used the same way as the DataPumpTransformLowerString object in the example in that section, except that it is created as follows:
Set oTransform = oCustTask.Transformations. _
New("DTSPump.DataPumpTransformUpperString")
See Also
DataPumpTransformMidString Object