DTS Programming
MaximumErrors Property
The MaximumErrors property specifies the maximum number of errors that can occur before the server terminates the load operation.
Applies To
| BulkInsertTask Object |
Syntax
object.MaximumErrors [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to a BulkInsertTask object |
| value | Maximum number of errors that can occur |
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetMaximumErrors(LONG *pRetVal);
HRESULT SetMaximumErrors(LONG NewValue);
Remarks
The default is 10.
Transformations will fail at the first error if Fastload is being used as long as the BatchSize property is 0, even if MaximumErrors is changed. This failure occurs 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 BatchSize property to another value, such as 1.