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'.
The solution can be found at here.
Edit "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe.config" (run Notepad, etc. as Administrator), and comment out/delete
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'.
Comments