在做SSIS项目的Data Coversion时，经常会遇到类似如下两个问题：

 1.Validating (Error)

       Messages

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

          (SQL Server Import and Export Wizard)

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

          (SQL Server Import and Export Wizard)

    解决：检查你源数据库和目标数据库的排序规则是否不一致，如果Code Page不一致，就会出现大量上面错误。

  2：在验证时出现下面错误信息

- Validating (Error)

            Messages

                  * Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "xxxxx".

                  (SQL Server Import and Export Wizard)

                  * Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.

                  (SQL Server Import and Export Wizard)

    解决：出现这个错误，是因为这一列是自动增长，需要在”Edite Mappings" 选项里面勾选“Enable Identity Insert”选项。