Column validation error for cannot be processed because more then one code issue

Question

Column validation error for cannot be processed because more then one code issue

Jinal Contractor 121

I'm trying to download the FILES from FTP server and import into SQL Database>Table connecting via Flat File Source > OLE DB Destination and getting multiple columns error.

Error:- The Column "Column Name" cannot be processed because more than one code page (65001 and 1252) are specified for it.

Attached is the screenshot.

Accepted answer

0 additional answers

Your answer

Answer 1

ZoeHui-MSFT 41,491

Hi @Jinal Contractor ，

Error:- The Column "Column Name" cannot be processed because more than one code page (65001 and 1252) are specified for it.

From the error message, you are trying to map a column from a value with Code Page 65001 (UTF-8) to a value with 1252 (ANSI - Latin I).

You may add Data Conversion component or Derived Column Transformation between your source component and destination.

Or you may go to OLE DB Destination- click "Show Advanced Editor" in the right bottom corner- open tab: Component Properties- set DefaultCodePage = 65001 (or 1252)- set AlwaysUseDefaultCodePage = true.

Details you may refer to ssis-code-page-goes-back-to-65001.

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Jinal Contractor 121 Reputation points

2022-02-01T01:56:50.553+00:00

Hello,
Thank you for your response.

I I did map a column from a value with Code Page 65001 (UTF-8) to a value with 1252 (ANSI - Latin I). But OLE DB destination is getting failed.

ERROR:-
.

Error: 0xC0047022 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (75) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (88). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Source [2]: The processing of file "E:\checkins.csv" has ended.
Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 0 rows.

Share via

Column validation error for cannot be processed because more then one code issue

0 additional answers

Your answer