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