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

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 ?

image_thumb3111

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

image_thumb[2]

We can set properties through SSIS Designer or programmatically.

How to use Character Map Transformation Task ?

Select task from data flow transformation

image_thumb[4]

Click on Edit to have an overview

image_thumb[5]

We select check box whatever column we need to transform

image_thumb[16]

Once we select column we can perform operation

image_thumb[16]

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

image_thumb[17]

We have following various option in terms of operation

image_thumb[19]

We can save or defined output column name

image_thumb[21]

We also have configuration error output to track errors in transformation

image_thumb[22]

image_thumb[24]

Lets put some Data viewer Grid for Data Analysis

image_thumb[12]

Name in Initial Stage

image_thumb[26]

Name in final stage

image_thumb[27]

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 ?

image

Reference link For Character Map Transformation Task

 

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

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

Add yours

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

Blog at WordPress.com.

Up ↑

%d bloggers like this: