Lowercase String Transformation

Data Transformation Services

Data Transformation Services

Lowercase String Transformation

The Lowercase String transformation converts a source column to lowercase 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. For more information, see Copy Column Transformation.

The Lowercase String transformation is an example of an N-to-N transformation mapping. Any number of source columns may be selected, as long as each is provided a matching destination column. For more information, see Mapping Column Transformations.

To convert a string to lowercase characters