szpic szpic - 4 months ago 18
SQL Question

Collation error during exporting data

I'm trying to copy data from one database to another with built-in export tool.
but I get this error:

Error 0xc02020f4: Data Flow Task 1: The column "Name" cannot be processed because more than one code page (1250 and 1252) are specified for it.
(SQL Server Import and Export Wizard)



Error 0xc02020f4: Data Flow Task 1: The column "CatalogNo" cannot be processed because more than one code page (1250 and 1252) are specified for it.
(SQL Server Import and Export Wizard)

Error 0xc004706b: Data Flow Task 1: "Destination - Device" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
(SQL Server Import and Export Wizard)


Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
(SQL Server Import and Export Wizard)

I know that error:

Error 0xc004706b: Data Flow Task 1: "Destination - Device" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)


Is probably caused by wrong order of copying data. ( FK)

And the first two errors are caused by not the same collation in the columns.

Databases and tables have same collation. How can I set columns to use table default collation?
I tried to change this manually but in collation list on the column lvl there is no collation set for table and db.

Answer

Ok. I change It manually in Design ->Collation->Restore default after that I copied all the data.

Comments