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.
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.
Thanks a lot
ReplyDeleteIt works fine.......
thank you so much...it saved me time...
ReplyDeletethat fix that issue. thx
ReplyDeleteThank you very much
ReplyDelete