ErrorConfiguration Element (XMLA)

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