The MaximumErrors property specifies the maximum number of errors that can occur before the server terminates the load operation.
| BulkInsertTask Object |
object.MaximumErrors [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Maximum number of errors that can occur |
The default is 10.
Transformations will fail at the first error if Fastload is being used, even if MaxErrors is changed, as long as the insert commit size is 0. This is because all the rows are batched in a single transaction. If you want to log more errors to the exception file, either do not use Fastload or set the insert commit size to another value, such as 1.
Long
Read/write
HRESULT GetMaximumErrors(LONG *pRetVal);
HRESULT SetMaximumErrors(LONG NewValue);