MaxErrors option

Specifies the number of errors at which the system stops processing rows. If the count of rejected rows reaches this threshold, the system immediately ends and rolls back the load.

The default value is 1. This default causes the system to commit a load only if it contains no errors. A MaxErrors value of n (where n is greater than 1) allows the first n - 1 row rejections to be recoverable errors, not including the number of rows that were processed in the skipped row range.

Possible values of this option are 0 (unlimited errors) - 2,147,483,647 (the largest signed 32-bit integer).

This option is different for the fixed-length format. For more information, see Changes in option behavior for the fixed-length format.