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.
