This was another interesting issue I encountered recently. The error presented itself as an event log entry from our logging as below:
Unhandled Exception: System.Data.DataException: <target>.Column2 and <source>.Column2 have conflicting...