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.