Import/export wizard code page error Using the Import/Export Wizard, I ended up with an annoying problem:


  Error 0xc02020f4: Data Flow Task 1: The column "pinNumber" cannot be processed because more than one code page (874 and 1252) are specified for it.


Looks like a different codepage (SQL_Latin1_General_CI_AS vs Latin1_General_CI_AS), so I changed those to match: Latin1_General_CI_AS for both.

However, the wizard still throws an error and detects two codepages - I even checked the tables and both source and destination show the same Latin1_General_CI_AS collation.
Problem can be in field level as it was for me.

In a source database, a field in a table had a different collation in a varchar datatype.

If you choose &lt; database default>  for collation property of the fields, the problem may be solved.