In My SSIS, I got the following error when I changed the Data type through Data Conversion component.
Error:
Data Flow Task: The column "" cannot be processed because more than one code page (1256 and 1252) are specified for it. (SQL Server Import and Export Wizard)
When we searched the forums, most common answer found was to set AlwaysUseDefaultCodePage=true in Properties.
When I did the same it worked for me
Regards
Fauzi
6 comments:
Rather cool place you've got here. Thanks the author for it. I like such topics and anything that is connected to them. I would like to read a bit more on that blog soon.
Best regards
"to set AlwaysUseDefaultCodePage=true in Properties"
properties of what?
For Destination Data flow Component
Thanks for reply
I already detected that this error does not appear if I remove the last/destination data flow task, i.e. something wrong exactly in it.
But playing with AlwaysUseDefaultCodePage and DefaultCodePage did not help.
I googled for everything and cannot understand where is from or why this error
("more than one code page")...
I cannot get rid of it...
Having read this material, I have learned for myself a lot of the new. Thanks
Today I faced same issue and found that source and target is having the property ‘defaultcode pace/codepage’ value is different (it should be same default value is1252). After changing the property ‘cadepage’ it is working fine.
Post a Comment