How does one troubleshoot this issue?
"Operation on target XYZ CSV failed: Failure happened on 'Sink' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.InvalidOperationException,Message=Column 'ABC' does not allow DBNull.Value.,Source=System.Data,'
I have:
- Verified that every row in the data source has a value for that column
- Verified that "First row as header" is turned on for the source
- I have turned on fault tolerance and still get the same error. 0/399,112 records imported
- Have turned on logging for the copy activity and get nothing in the log except it says it picked up and processed the file.
- Verified that all other non-null fields always have data
How do you troubleshoot this issue? The error message given is so vague, and doesn't even point to a specific row.