Dimension Processing Destination Custom Properies
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.