Monthly Archives: September 2014

Error 0xc004706b: failed validation and returned validation status “VS_ISBROKEN”. (SQL Server Import and Export Wizard)

It happens during exporting the data, while source table has identity columns and destination one as well.

Step 1: Edit Mappings


Step 2: Check Enable identity insert


The reason why I got this error was because my destination table had the IDENTITY property set on ID column, which was not allowing do any inserts using the export wizard. This is because identity column values are automatically generated.

Enabling the Enable Identity Insert option allows values to be inserted in the identity field and desired values are moved from source database to destination table.