SQL Server SSIS Sample Component: CodePageConvert

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


      File Name:


      Date Published:


      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.
    • Supported Operating System

      Windows 2000, Windows Server 2003, Windows XP

        SQL Server 2005; Visual Studio 2005
      • Install and build as directed in readme.txt

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial