ErrorConfiguration Element (XMLA)

  • Article

Specifies settings for handling errors that can occur during a Batch or Process operation.

Syntax

<Batch> <!-- or Process -->
   ...
   <ErrorConfiguration>
      <KeyErrorLimit>...</KeyErrorLimit>
      <KeyErrorLogFile>...</KeyErrorLogFile>
      <KeyErrorAction>...</KeyErrorAction>
      <KeyErrorLimitAction>...</KeyErrorLimitAction>
      <KeyNotFound>...</KeyNotFound>
      <KeyDuplicate>...</KeyDuplicate>
      <NullKeyConvertedToUnknown>...</NullKeyConvertedToUnknown>
      <NullKeyNotAllowed>...<NullKeyNotAllowed>
   </ErrorConfiguration>
   ...
</Batch>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

Batch, Process

Child elements

KeyDuplicate, KeyErrorAction, KeyErrorLimit, KeyErrorLimitAction, KeyErrorLogFile, KeyNotFound, NullKeyConvertedToUnknown, NullKeyNotAllowed

Remarks

The structure of this element is identical to the structure of the ErrorConfiguration element in Analysis Services Scripting Language (ASSL). For more information about the ErrorConfiguration element, see ErrorConfiguration Element (ASSL).

See Also

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance