Partition Processing Destination


Applies To: SQL Server 2016

The Partition Processing destination loads and processes an SQL Server Analysis Services partition. For more information about partitions, see Partitions (Analysis Services - Multidimensional Data).

The Partition Processing destination includes the following features:

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

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

  • Mapping of input columns to partition columns.

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

System_CAPS_ICON_note.jpg Note

Tasks described here do not apply to Analysis Services tabular models. You cannot map input columns to partition columns for tabular models. You can instead use the Analysis Services Execute DDL task Analysis Services Execute DDL Task to process the partition.

The Partition Processing destination uses an Analysis Services connection manager to connect to the Analysis Services project or the instance of Analysis Services that contains the cubes and partitions 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 Partition 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 topics:

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

Community Additions