June 1, 2011

Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "--". (SQL Server Import and Export Wizard)

I was using Import /Export Wizard of sqlserver2005 to Import the data
and got the following error


Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "PictureId".
(SQL Server Import and Export Wizard)




Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)


Error 0xc004706b: Data Flow Task: "component "Destination - YvGroup" (40)" failed validation and 


returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)


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


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


Solution:

Check the  "Enable identity insert" checkbox when you click the "Edit Mappings" button next to each table in the import wizard.


4 comments: