SQL Server SSIS Sample Component: CodePageConvert

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

    Date Published:



    File name:
    File size:


    122 KB

      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.
  • System Requirements

    Supported Operating System

    Windows 2000, Windows Server 2003, Windows XP

      SQL Server 2005; Visual Studio 2005
  • Install Instructions

      Install and build as directed in readme.txt
  • Related Resources

Popular downloads

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers
Run Microsoft Update