SSIS - How to Use "Character Map" Transformation (LowerCase, UpperCase) in SSIS Package

Scenario:

Let’s say we are extracting data from a source and we have to write to flat file or excel but before we write data we want to format one column to lower case and other column to upper case.

Solution:


SSIS provided us a transformation called “Character Map” that can perform different operations on string type columns. We can either add a new column or we can do In-place change for that column. We used Uppercase and lowercase operations on CountryName and SalePersonName respectively. The same operations can be done by using Derived column transformation. 


As shown below, We added a new column CountryName_Upper and used Uppercase as operation on CountryName column. For SalePersonName we did In-place change and changed to lowercase.
How to use Character Map Transformation in SSIS Package to convert string values to Lowercase or UpperCase

Output snapshot
What is Character Map Transformation and How to use in SSIS Package


Video Demo : How to use Character Map Transformation in SSIS Package


To learn more about different operations available in Character Map transformation, Please visit 

2 comments:

  1. Among the trendy superhero wear gaining fame fast is the Black Panther costume. This makes it the best outfit for cosplay and Halloween or any other dress up event. It has all the usual superhero and superheroine flare and it has some slight improvement from the usual attires donned by other screen heroes. hire Black Panther

    ReplyDelete