Mistake: ignore rejected rows because the load can continue. If data matters enough to load, it matters enough to retain for review, even when repair may be difficult. section 6.1
Configure a failure table by:
- Creating a table with expansive columns for the rejected source row, error code, and error column. section 6.1
- Adding an OLE DB destination and connecting the data source's error output to it. section 6.1
- Setting the source error output to redirect errors and truncations, then manually mapping its output column. section 6.1
Malformed delimiter
A row expected to be comma-separated contains a semicolon after its first GUID. The resulting 53-character value exceeds a 50-character Cookie ID column, producing a truncation failure that the failure table preserves for examination. section 6.1
