SQL Server 2008 and 2008 R2 Integration Services - Partition Processing Data Flow Destination

The primary purpose of Integration Services technology is to deliver extraction, transformation, and loading functionality that supports core features of SQL Server database management systems. However, there are numerous scenarios where its role involves interaction with components that provide Business Intelligence-related features. In this article, we will discuss one such scenario, which leverages built-in SSIS Partition Processing Data Flow Destination in order to facilitate Analysis Services processing.