SQL Server SSIS Sample Component: CodePageConvert

Brief Description

CodePageConvert is an SSIS dataflow component that translates from and to any code page or unicode character representations.

Overview

It takes two SSIS data convert transforms to convert from one DT_STR code page to another.

The CodePageConvert transform is a single transform that converts input text to either unicode or a named code page, depending on configuration. Configuration is minimal. A custom UI would make it more so.

Configure in advanced editor by, on the component properties tab, setting "ConvertToUnicode" true or false, then, if false, additionally setting the desired value for "CodePage". Then, on the Input Columns tab, select input columns containing DT_STR or DT_WSTR values.

This component automatically creates an output column when the input column is selected, then forbids any change except string length.

DT_STR columns are initially set to have lengths twice that of the associated input column, to account for DBCS character sets. Users of fancier character sets, like utf-8, may have to manually increase the length of the column to prevent truncation (which will fail the component if encountered.)

This component was created starting from the UnpackDecimal sample.

Top of page