MSBI # 61 – SSIS # 25 – Data Flow Task # 11 – Character Map Transformation – Detailed information & Explanation with example , Use & Properties

Hi folks,

Continuing from my last post on transformation task

• MSBI # 57 – SSIS # 22 – Data Flow Task # 8 – Aggregate Transformation Task
• MSBI # 59 – SSIS # 23 – Data Flow Task # 9 – Audit Transformation Task
• MSBI # 60 – SSIS # 24 – Data Flow Task # 10 – Cache Transform Task

In this article we are going to cover

• Why Character Map Transformation Task is Use ?
• How Character Map Transformation Task is look like ?
• Features of Character Map Transformation Task
• How to use Character Map Transformation Task ?
• What is alternative For Each Character Map Transformation Task ?
• Demonstration of using Character Map Transformation Task ?
• Various Properties For each Character Map Transformation Task ?
• Reference link For Character Map Transformation Task

Why Character Map Transformation Task is Use ?

Using Character Map we can perform miner operation on database before using it into main Data Repository or Data Warehouse

Character Map transformation is use as transforming of string into required format.

Character Map transformation is useful for string conversion

Also operates only on column data with a string data type.

We can configure the Character Map transformation in the following ways:

• Specify the columns to convert.
• Specify the operations to apply to each column.
• The Character Map transformation includes an error output, which can be used to direct truncated data to separate output

How Character Map Transformation Task is look like ?

Features of Character Map Transformation Task  / Demonstration of using Character Map Transformation Task ?

The following table describes the mapping operations that the Character Map transformation supports

We can set properties through SSIS Designer or programmatically.

How to use Character Map Transformation Task ?

Select task from data flow transformation

Click on Edit to have an overview

We select check box whatever column we need to transform

Once we select column we can perform operation

.We can change Destination to new or we can In-place change

We have following various option in terms of operation

We can save or defined output column name

We also have configuration error output to track errors in transformation

Lets put some Data viewer Grid for Data Analysis

Name in Initial Stage

Name in final stage

What is alternative For Each Character Map Transformation Task ?

According to me there are various option like derived column but operations provide here are very specific operation and these are faster that we will do in expression.

Various Properties For each Character Map Transformation Task ?

Reference link For Character Map Transformation Task

• Character Map Transformation
• Character Map Transformation Editor
• Character Map Transformation | SQL Server Rider

 

Hope this helps !!

Hope you have understood Character Map Transformation task in SSIS and ready to use every aspects for same

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Dactylonomy of Web Resource