• Article

Partition Processing Destination

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.

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.

Configuring the Partition Processing Destination

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 How to: Set the Properties of a Data Flow Component.

External Resources

Blog entry, How to use Partition Processing Destination Task to pump data into a SSAS partition via SSIS, on blogs.msdn.com.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN

For automatic notification of these updates, subscribe to the RSS feeds available on the page.