I simply want to log any errors that occur in a Bulk Insert task.
I'm simply going from a flat file to a table and it's all working fine, except for the error logging.
I have logging set up and it's partially working - only a single error is reported.
Say I have five rows in the input file and rows 3 and 5 have "bad" data (incorrect types, too long, whatever). When the Bulk Insert task runs, the "bad" records don't get inserted which is correct.
The problem is that only the first errored line (row 3) gets reported and logged. How can I get ALL errors and warning to get logged?