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 : 37827 | Status : [Member] [MVP] | Replies : 3

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



Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response