Character Map Transformation Editor

Use the Character Map Transformation Editor dialog box to select the string functions to apply to column data and to specify whether mapping is an in-place change or added as a new column.

To learn more about the Character Map transformation, see Character Map Transformation.

Options

  • Available Input Columns
    Use the check boxes to select the columns to transform using string functions. Your selections appear in the table below.
  • Input Column
    View input columns selected from the table above. You can also change or remove a selection by using the list of available input columns.
  • Destination
    Specify whether to save the results of the string operations in place, using the existing column, or to save the modified data as a new column.
<table>
<colgroup>
<col style="width: 50%" />
<col style="width: 50%" />
</colgroup>
<thead>
<tr class="header">
<th>Value</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr class="odd">
<td><p>New column</p></td>
<td><p>Save the data in a new column. Assign the column name under <strong>Output Alias</strong>.</p></td>
</tr>
<tr class="even">
<td><p>In-place change</p></td>
<td><p>Save the modified data in the existing column.</p></td>
</tr>
</tbody>
</table>
  • Operation
    Select from the list the string functions to apply to column data.
<table>
<colgroup>
<col style="width: 50%" />
<col style="width: 50%" />
</colgroup>
<thead>
<tr class="header">
<th>Value</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr class="odd">
<td><p>Lowercase</p></td>
<td><p>Convert to lower case.</p></td>
</tr>
<tr class="even">
<td><p>Uppercase</p></td>
<td><p>Convert to upper case.</p></td>
</tr>
<tr class="odd">
<td><p>Byte reversal</p></td>
<td><p>Convert by reversing byte order.</p></td>
</tr>
<tr class="even">
<td><p>Hiragana</p></td>
<td><p>Convert Japanese katakana characters to hiragana.</p></td>
</tr>
<tr class="odd">
<td><p>Katakana</p></td>
<td><p>Convert Japanese hiragana characters to katakana.</p></td>
</tr>
<tr class="even">
<td><p>Half width</p></td>
<td><p>Convert full-width characters to half width.</p></td>
</tr>
<tr class="odd">
<td><p>Full width</p></td>
<td><p>Convert half-width characters to full width.</p></td>
</tr>
<tr class="even">
<td><p>Linguistic casing</p></td>
<td><p>Apply linguistic rules of casing (Unicode simple case mapping for Turkic and other locales) instead of the system rules.</p></td>
</tr>
<tr class="odd">
<td><p>Simplified Chinese</p></td>
<td><p>Convert traditional Chinese characters to simplified Chinese.</p></td>
</tr>
<tr class="even">
<td><p>Traditional Chinese</p></td>
<td><p>Convert simplified Chinese characters to traditional Chinese.</p></td>
</tr>
</tbody>
</table>
  • Output Alias
    Type an alias for each output column. The default is Copy of followed by the input column name; however, you can choose any unique, descriptive name.
  • Configure Error Output
    Use the Configure Error Output dialog box to specify error handling options for this transformation.

See Also

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance