Post reply

Convert UTF-8 format flat file in SSIS

  • March 28, 2012 at 5:48 am

    #253858

    I’m running one SSIS package to import data from flat file send from SAP to MSSQL 2005 Server.

    Due the UTF-8 format of flat file SSIS is reading and inserting the following respectively.

    Original Inserted by SSIS

    'ü' 'ü'

    'ß' 'ß'

    'ä' 'ä'

    'ö' 'ö'

    I tried Unicode conversion which also dint work.

    The collation of my MSSQL 2005 database is SQL_Latin1_General_CP1_CI_AS.

    Please help me resolve this issue.

    Tanx 😀

  • March 28, 2012 at 12:05 pm

    #1465891

    Eswin (3/28/2012)

    I tried Unicode conversion which also dint work.

    Do you mean you checked the Unicode box in the SSIS File Connector?

    That checkbox is a shortcut to use UCS-2 encoding. You need to uncheck that box and change the Code Page to 65001 (UTF-8) to instruct SSIS properly on how to read the file.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply