SQL Server或者SSIS导入文件到数据库时，出现code page错误（转载）

有时候当我们用SQL Server的导入向导或者SSIS导入文件到数据库时，会出现类似下面的错误：

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

 

这个错误的原因和解决办法如下：

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.

 

 

原文链接