Character Map Transformation

The Character Map transformation applies string functions, such as conversion from lowercase to uppercase, to character data. This transformation operates only on column data with a string data type.

Step 1:

Click Windows button and go to SQL Server 2008 R2 and run as a administrator.

It shows a bellow window.

Step 2:

Go to a views and create a new project (Short cut of New Project is Ctrl + Shift + N).

 Step 3:

Give a project name (e.g. IS) and click OK button and then shows a bellow window.

Step 4:

To drag and drop the Data Flow Task

Step 5: 

To edit the Data Flow Task then it open a Data Flow

Stem 6:

To dag and drop the OLEDB source and edit it.

Step 7:

To take OLEDB connection and select the table from given data base and select which columns are required.

Step 8:

Drag and drop character map and edit it.

Step 9:

To select the column you want to convert into lower case to upper case.

Step 10:

Drag and drop the data reader destination and edit it.

Step 11:

To take a data reader function

Step 12:

Execute the task.