First of all, if you get 'Unexpected Unrecover error'.
The solution can be found at here.
After that you may encounter error 'Failure Inserting Into Read Only Column'.
This usually happens when the destination column is a identity column type.
To solve this issue, make sure you skip those columns which are identity column type by marking it as 'ignore'.