Using SSIS to Transfer Data from a SSAS Cube
Scenario
A process needs to be built that will take the aggregate data from your SSAS cube and transfer that data as a source for a third party application. This process will need to be scheduled and have the capability to execute when requested.
Solution
Using SSIS to transfer the data is a great tool to meet the requirements above since you can build the process and schedule it as required as well as run the package when requested.
Since the tool has been established, the question now becomes how to get SSIS to connect to the cube and then work with the results.
The following document lays out a step by step approach to get the initial connection to the SSAS cube, sample MDX to query the cube and the cleanup steps within SSIS to perform against the data to have it usable going forward.
Tags: ssis