Dimension Processing Destination
Collapse the table of content
Expand the table of content

Dimension Processing Destination


Applies To: SQL Server 2016

The Dimension Processing destination loads and processes an SQL Server Analysis Services dimension. For more information about dimensions, see Dimensions (Analysis Services - Multidimensional Data).

The Dimension Processing destination includes the following features:

  • Options to perform incremental, full, or update processing.

  • Error configuration, to specify whether dimension processing ignores errors or stops after a specified number of errors.

  • Mapping of input columns to columns in dimension tables.

For more information about processing Analysis Services objects, see Processing Options and Settings (Analysis Services).

The Dimension Processing destination uses an Analysis Services connection manager to connect to the Analysis Services project or the instance of Analysis Services that contains the dimensions the destination processes. For more information, see Analysis Services Connection Manager.

This destination has one input. It does not support an error output.

You can set properties through SSIS Designer or programmatically.

For more information about the properties that you can set in the Dimension Processing Destination Editor dialog box, click one of the following topics:

The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topic:

For more information about how to set the properties, see Set the Properties of a Data Flow Component.

Community Additions

© 2016 Microsoft