" ... more than one code page (950 and 1252) are specified for it.

• onlo

  SSCertifiable

  Points: 5080

  More actions

  June 2, 2010 at 4:51 am

  #223359

  Hello,

  I had the above problem when I tried to use SSIS package through SQL Agent Job to load records into SQL 2008, some of the columns are Chinese characters, so I used the following settings in my Flat File Connection Manager :

  Locale : English (United States),

  NOT clicked Unicode but Code page was : 950 (ANSI/OEM - Traditional Chinese Big5)

  Data source : text file (Encoding : ANSI)

  I got the above error when I executed the SQL Agent Job.

  If I chose 1252 (ANSI - Latin1) Code page, no error but the Chinese became garbage.

  How can I use SSIS package to load both English and Chinese into SQL 2008 ?

  Please help me.

• Paul White

  SSC Guru

  Points: 150468

  More actions

  June 2, 2010 at 5:40 am

  #1175220

  I'm intrigued to see how you have Chinese characters in a non-Unicode source file.

  Could you provide a small sample file for us to experiment with?

  Just a few rows and the destination table definition would be awesome, thanks.

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi