SQL Server The column cannot be processed because more than 1 code page (65001 and 1252) are specified for it

Question

I did a select * on a table. I exported the results and tried to import it and write to another table (I have to do this via SSIS, I cannot do this via SQL Server (i.e. select into) for security permission purposes, but I can do it this way).

How can I fix this error? What exactly does it mean? I tried searching StackOverflow but my search was not very helpful.

I tried to use an OLEDB source step, but my server instance does not appear for some reason, so now I'm trying to export/import out of SSMS.

Answer 1

I usually get this error while im having a destination and a source with different codepages. it seems that you have a flat file with a 1252 codepage and a destination table with 65001 codepage (or vice versa). You should try Data Conversion component between your source component and destination.

Answer 2

You are trying to map a column from a value with Code Page 65001 (UTF-8) to a value with 1252 (ANSI - Latin I) or vice versa. To fix that, I recommend you to include a task of type Derived Column and add a new column with the appropriate Code Page. Now you must obtain an output with the appropriate encoding to retrieve the data.

Answer 3

I had same issue. I resolved it setting AlwaysUseDefaultCodePage settings as True and setting the DefaultCodePage as 65001 (same as source file).

Screenshots below.