Edit

Dimension Processing Destination Custom Properies

  • Article

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

The Dimension Processing destination has both custom properties and the properties common to all data flow components.

The following table describes the custom properties of the Dimension Processing destination. All properties are read/write.

Property Data Type Description
ASConnectionString String The connection string to an instance of Analysis Services or to an Analysis Services project.
KeyDuplicate Integer (enumeration) When UseDefaultConfiguration is False, a value that indicates how to handle duplicate key errors. The possible values are IgnoreError (0), ReportAndContinue (1), and ReportAndStop (2). The default value of this property is IgnoreError (0).
KeyErrorAction Integer (enumeration) When UseDefaultConfiguration is False, a value that indicates how to handle key error. The possible values are ConvertToUnknown (0) and DiscardRecord (1). The default value of this property is ConvertToUnknown (0).
KeyErrorLimit Integer When UseDefaultConfiguration is False, the upper limit of key errors that are enabled.
KeyErrorLimitAction Integer (enumeration) When UseDefaultConfiguration is False, a value that indicates the action to take when KeyErrorLimit is reached. The possible values are StopLogging (1) and StopProcessing (0). The default value of this property is StopProcessing (0).
KeyErrorLogFile String When UseDefaultConfiguration is False, the path and file name of the error log file.
KeyNotFound Integer (enumeration) When UseDefaultConfiguration is False, a value that indicates how to handle missing key errors. The possible values are IgnoreError (0), ReportAndContinue (1), and ReportAndStop (2). The default value of this property is IgnoreError (0).
NullKeyConvertedToUnknown Integer (enumeration) When UseDefaultConfiguration is False, a value that indicates how to handle null keys converted to the unknown value. The possible values are IgnoreError (0), ReportAndContinue (1), and ReportAndStop (2). The default value of this property is IgnoreError (0).
NullKeyNotAllowed Integer (enumeration) When UseDefaultConfiguration is False, a value that indicates how to handle disallowed nulls. The possible values are IgnoreError (0), ReportAndContinue (1), and ReportAndStop (2). The default value of this property is IgnoreError (0).
ProcessType Integer (enumeration) The type of dimension processing the transformation uses. The values are ProcessAdd (1) (incremental), ProcessFull (0), and ProcessUpdate (2).
UseDefaultConfiguration Boolean A value that specifies whether the transformation uses the default error configuration. If this property is False, the transformation includes information about error processing.

The input and the input columns of the Dimension Processing destination have no custom properties.

For more information, see Dimension Processing Destination.

See Also

Common Properties