Character Map Transformation
It is a very simple column transformation task which performs string conversions like lower case to upper case, etc. There are other operations available for this task.
In this article, I will be showing you, how to use this task to convert a string column from lower case to upper case.
Step 1: Create a package. Add a data source task and configure a table which is having string column.
Step 2: Add Character Map transformation task and connect pipeline from data source task to character map task
Step 3: Open Character Map task editor and configure the task as shown in the picture. Destination option can be set to add new column or replacing the original column with converted value.
Step 4: Add a Union all task and add data viewer between character map task and union all task to view the result.
Learn more about Character Transformation in MSDN.
Thanks for reading.