The column "Column 0" cannot be processed because more than one code page (65001 and 1252) are speci

Posted by Bandi under Error and Solution on 9/16/2014 | Points: 10 | Views : 68028 | Status : [Member] [MVP] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

[Resolved]

Hi All,

Yesterday, i faced the below error while loadin gflat file data to destination SQL Server table.

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

Fix for the above issue i have done is:
Go to Destination OLE DB destination task's properties and then set AlwaysUseDefaultCodePage option to TRUE and DefaultCodePage to 65001.

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 9/17/2014 [Member] [MVP] Platinum | Points: 25

0	you are very welcome to post the replies if any other solution works for the above issue Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Bandi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naveenhcl on: 9/17/2014 [Member] Starter | Points: 25

0	Hi, Good to here resolve the issues by your own keep up with the same manner. Bandi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 9/17/2014 [Member] [MVP] Platinum | Points: 25

0	http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6d4eb033-2c45-47e4-9e29-f20214122dd3/ssis-change-code-page-1252-ansi-to-utf8-65001?forum=sqlintegrationservices Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Bandi, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts