TechNet
Export (0) Print
Expand All

Dimension Processing Destination Custom Properies

 

Applies To: SQL Server 2016

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.

PropertyData TypeDescription
ASConnectionStringStringThe connection string to an instance of Analysis Services or to an Analysis Services project.
KeyDuplicateInteger (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).
KeyErrorActionInteger (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).
KeyErrorLimitIntegerWhen UseDefaultConfiguration is False, the upper limit of key errors that are enabled.
KeyErrorLimitActionInteger (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).
KeyErrorLogFileStringWhen UseDefaultConfiguration is False, the path and file name of the error log file.
KeyNotFoundInteger (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).
NullKeyConvertedToUnknownInteger (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).
NullKeyNotAllowedInteger (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).
ProcessTypeInteger (enumeration)The type of dimension processing the transformation uses. The values are ProcessAdd (1) (incremental), ProcessFull (0), and ProcessUpdate (2).
UseDefaultConfigurationBooleanA 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.

Common Properties

Community Additions

ADD
Show:
© 2016 Microsoft