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.