Character Map transformation is SSIS transformation and It is very useful to change the formatting of columns based on below operations.
This Transformation supports below mentioned operations.
Operation | Description |
Lowercase | Converts the characters to lowercase |
Uppercase | Converts the characters to uppercase. |
Byte reversal | Reverses the bytes order of the Unicode |
Hiragana | Converts Katakana characters to Hiragana characters. |
Katakana | Converts Hiragana characters to Katakana characters. |
Half width | Converts Full-width characters to Half-width characters. |
Full width | Converts Half-width characters to Full-width characters. |
Linguistic casing | Use linguistic casing option instead of the system language. |
Simplified Chinese | Converts traditional Chinese characters to simplified Chinese characters.
|
Traditional Chinese | Converts simplified Chinese characters to Traditional Chinese characters.
|
For this transformation,We are explaining the example How to change string columns formatting by using Character Map Transformation.
Step 1) Drag and drop OLE DB Sources, Character Map Transformations and OLE DB Destination from SSIS toolbox into data flow tab.
Step 2) Now Double click on OLE-DB source, OLE-DB source editor window will open and need to select table.
Step 3) Click on the columns tab to check the columns and click on “ok” button.
Step 4) Double click on the Character Map Transformation, Character Map Transformation editor window will open to apply the string operations to columns with character data.
Here, we want to display “Name” in Lowercase .
Step 5) Double Click on OLE DB destination , OLE DB destination editor window will open to configure below table in Server.
CREATE TABLE [CharacterMap Data] (
[ID] int,
[Name] varchar(50),
[Salary] numeric(18,0),
[DepartmentID] int,
[ContactNo] numeric(18,0),
[Copy of Name] varchar(50)
)
Step 6) Click on the Mappings tab to check the columns.
Step 7) Click on “Ok” button to complete the configuration and execute the package to check the result in database.
Step 8) Open SQL Server Management Studio to check the output.
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.