Failure inserting into the read-only column
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.
本文数据库（mssql）相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库