SQL SSIS Error: The column “Column 2” cannot be processed because more than one code page (65001 and 1252) are specified for it.

I have data I wrote to csv in utf-8 format. Now, I want to update an SQL table using SSIS. I create the package and run the import but I get an error

The column “Column 2” cannot be processed because more than one code page (65001 and 1252) are specified for it.

Here is what I did to resolve this error

  1. Edit the package with Notepad
  2. Replace the following in the file
  • name=”DefaultCodePage”>1252</property> change to name=”DefaultCodePage”>65001</property>
  • name=”AlwaysUseDefaultCodePage”>false</property> change to name=”AlwaysUseDefaultCodePage”>true</property>
  • Replace all codePage=”1252″ to codePage=”65001″

 

 

Advertisements

3 thoughts on “SQL SSIS Error: The column “Column 2” cannot be processed because more than one code page (65001 and 1252) are specified for it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s