Uppercase String Transformation
The Uppercase String transformation converts a source column to all uppercase characters and, if necessary, to the destination data type. Both the source and destination columns must be a string data type. Multiple source columns may be processed in a single transformation.
If the source data is too large to fit in the destination column, it is truncated.
The Uppercase String transformation is an example of an N-to-N transformation mapping. Any number of source columns can be selected, as long as each is matched to a destination column. For more information, see Mapping Column Transformations.
To convert a string to uppercase characters