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
- Edit the package with Notepad
- 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″