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″
tlktechidentitythoughts 
where does the package reside?
LikeLike
Resides on the server local drive.
LikeLike
Thank you!!! I wasted so much time trying all kind of other suggestions. This is easy and quick and worked 100%. Thanks for sharing
LikeLike
This is really a life-saver! Thank you!
LikeLike
this error wasted my time thank you
LikeLike