Dimension Processing Destination Editor (Advanced Page)

 

Applies To: SQL Server 2016

Use the Advanced page of the Dimension Processing Destination Editor dialog box to configure error handling.

To learn more about the Dimension Processing destination, see Dimension Processing Destination.

Use default error configuration.
Specify whether to use the default Analysis Services error handling. By default, this value is True.

Key error action
Specify how to handle records that have unacceptable key values.

ValueDescription
ConvertToUnknownConvert the unacceptable key value to the UnknownMember value.
DiscardRecordDiscard the record.

Ignore errors
Specify that errors should be ignored.

Stop on error
Specify that processing should stop when an error occurs.

Number of errors
Specify the error threshold at which processing should stop, if you have selected Stop on errors.

On error action
Specify the action to take when the error threshold is reached, if you have selected Stop on errors.

ValueDescription
StopProcessingStop processing.
StopLoggingStop logging errors.

Key not found
Specify the action to take for a key not found error. By default, this value is ReportAndContinue.

ValueDescription
IgnoreErrorIgnore the error and continue processing.
ReportAndContinueReport the error and continue processing.
ReportAndStopReport the error and stop processing.

Duplicate key
Specify the action to take for a duplicate key error. By default, this value is IgnoreError.

ValueDescription
IgnoreErrorIgnore the error and continue processing.
ReportAndContinueReport the error and continue processing.
ReportAndStopReport the error and stop processing.

Null key converted to unknown
Specify the action to take when a null key has been converted to the UnknownMember value. By default, this value is IgnoreError.

ValueDescription
IgnoreErrorIgnore the error and continue processing.
ReportAndContinueReport the error and continue processing.
ReportAndStopReport the error and stop processing.

Null key not allowed
Specify the action to take when null keys are not allowed and a null key is encountered. By default, this value is ReportAndContinue.

ValueDescription
IgnoreErrorIgnore the error and continue processing.
ReportAndContinueReport the error and continue processing.
ReportAndStopReport the error and stop processing.

Error log path
Type the path of the error log, or click the browse(…) button to select a destination.

Browse (...)
Select a path for the error log.

Integration Services Error and Message Reference
Dimension Processing Destination Editor (Connection Manager Page)
Dimension Processing Destination Editor (Mappings Page)

Community Additions

ADD
Show: