The error message indicates that you are trying to insert data into a read-only column named "position_id." The most likely cause of this issue is that the destination table has a column that is marked as read-only, and you are trying to insert data into this column.
To fix this error, you need to modify the destination table and make sure that the "position_id" column is not marked as read-only. You can do this by using SQL Server Management Studio or any other database management tool that supports table modifications.
Here are the steps to modify the table:
Open SQL Server Management Studio and connect to the database server where the destination table is located.
- Navigate to the database that contains the destination table.
- Expand the "Tables" folder and locate the destination table.
- Right-click on the table and select "Design."
- Locate the "position_id" column and check its properties.
- Make sure that the "Is Identity" property is set to "No" and the "Read-Only" property is set to "No."
- Save the changes to the table.
- Re-run the SQL Server Import and Export Wizard.
By following these steps, you should be able to fix the error and successfully export data from one database to another.