Home > SSIS > Character Map Transformation

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.

Implementation

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: