MSSQL 2008 Export Tool Failure Inserting Into Read Only Column

First of all, if you get 'Unexpected Unrecover error'.

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'.