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