Error Limits For Load and Update Operators
The following example shows this variation for an operator with two instances and
an ErrorLimit attribute value of 1000:
If either operator instance reaches 1000, it will terminate the job with a fatal error.
In this case, the error limit is calculated per instance.
If instance #1 processes 500 error rows and instance #2 processes 500 error rows the
job will do the following:
If the job has already passed the final checkpoint (the transaction is fully committed),
the job will complete. In this case, the error limit is calculated per instance.
If the job reaches a checkpoint after logging the total of 1000 (500 + 500) errors, the job will terminate. In this case,
the error limit is calculated based on the total errors among all instances.