In My SSIS, I got the following error when I changed the Data type through Data Conversion component.
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