Export (0) Print
Expand All

Dimension Processing Destination Custom Properies

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.

Community Additions

ADD
Show:
© 2014 Microsoft