SQL Server import data frequently error answers

When you do data coversion for an SSIS project, you often encounter two issues like the following:

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) is 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) is specified for it.

(SQL Server Import and Export Wizard)

Workaround: Check if the collation of your source and target databases is inconsistent and there will be a large number of errors if the code page is inconsistent.

2: The following error message appears during validation

-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)

Workaround: This error occurs because this column is automatically growing and you need to check the "Enable Identity Insert" option in the "Edite Mappings" option.

MSDN's explanation for the code page is that for character and Unicode data, a code page is a definition of a bit pattern that represents a particular letter, number, or symbol (for example, 0x20 represents a space, and 0x74 represents the character "T"). Some data types use one byte per character, and the bit pattern for each byte can be one of 256 different bit patterns.

One solution you get today is:

When you import the Export Wizard with SQL Server, check the Enable Identity Insert option. After you save the SSIS package, if a code page error occurs. Then proceed to the next step:

Right-click the saved SSIS Package-edit, the Data Flow window appears, right-click the OLE DB source control, click Show Advanced Editor ...

Select Component Properties in the pop-up window, and set the property alwaysusedefaultcodepage here to True,defaultcodepage should also be 936.

So all two errors have been solved.