This short blog shows you on of the possible reasons you are getting the error “Failure inserting into the read-only column”.
When you are Exporting from one table to another in Microsoft SQL Server using the SQL Server Import and Export Wizard then you might have an error “Failure inserting into the read-only column” like the one below.
This is because your column value is an auto increase column.
Go back to Select Source Tables and Views page. Click on Edit Mappings.
Set the Destination column to <ignore>. You should have any problem if you re-run it again.
Hope that will save your minutes or even hours.