SSIS Character Map Transformation

  • Article

[[articles:SQL Server Integration Services (SSIS)|Integration Services]] uses transformations to manipulate data during an [[articles:Extract Transform Load (ETL)|ETL]] dataflow. Transformations can be used in [[articles:SSIS Dataflow Task|Data Flow Tasks]], between data source and destination components, or [[articles:SSIS: List of Transformations|other transformations]].

Alphanumeric values are often need transformation during a data flow: converting to upper- or lowercase is the most common case. This can be solved using the [[articles:SSIS Derived Column Transformation|Derived Column transformation]] as well - in combination with the UPPER or LOWER functions.

But Character Map has other features as well: reversing byte order, mapping katakana characters to hiragana characters (and vice versa), mapping half width characters to full width characters (and vice versa). There is an additional transformation - linguistic casing -, which uses an external reference to the Win32 API for Unicode simple case mapping of some locales.

The Character Map transformation supports an input, a regular and an error output.

For more detailed information on this transformation, please refer to this MSDN article.
For the complete list of SSIS transformations, check [[articles:SSIS: List of Transformations|this Wiki article]].