Partilhar via


Partition Processing Destination Editor (Advanced Page)

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

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

Options

  • 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.

    Value Description

    ConvertToUnknown

    Convert the unacceptable key value to the Unknown value.

    DiscardRecord

    Discard 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 error.
  • On error action
    Specify the action to take when the error threshold is reached, if you have selected Stop on error.

    Value Description

    StopProcessing

    Stop processing.

    StopLogging

    Stop logging errors.

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

    Value Description

    IgnoreError

    Ignore the error and continue processing.

    ReportAndContinue

    Report the error and continue processing.

    ReportAndStop

    Report the error and stop processing.

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

    Value Description

    IgnoreError

    Ignore the error and continue processing.

    ReportAndContinue

    Report the error and continue processing.

    ReportAndStop

    Report the error and stop processing.

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

    Value Description

    IgnoreError

    Ignore the error and continue processing.

    ReportAndContinue

    Report the error and continue processing.

    ReportAndStop

    Report 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.

    Value Description

    IgnoreError

    Ignore the error and continue processing.

    ReportAndContinue

    Report the error and continue processing.

    ReportAndStop

    Report the error and stop processing.

  • Error log path
    Type the path for the error log, or select a destination by using the browse (...) button.
  • Browse (...)
    Select a path for the error log.

See Also

Reference

Partition Processing Destination Editor (Mappings Page)
Partition Processing Destination Editor (Advanced Page)

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance