Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column
Solution 1:
With all due respect to Kishore's answer, that approach is valid if you're modifying the packages. Since you're using the import/export wizard, the more straight forward approach would be to check the Enable Identity Insert
box on the Column Mappings tab.
In the Import Export Wizard, after selecting the table for copy, click the Edit Mappings...
button
In the resulting screen, click the Enable identity insert
property and your identities will be replicated over.
Same net result as issuing SET IDENTITY_INSERT TableName ON
& OFF but this is done automagically at build time.
Solution 2:
Before Importing date execute the below query to set identity insert on:
SET IDENTITY_INSERT TableName ON
Then do the import operations.
After importing date execute the below query to set identity insert off:
SET IDENTITY_INSERT TableName OFF