SSIS - Process Cube with XMLA and Analysis Services DDL
Generating XMLA Script and data from Cube. What I was looking to do, was to use XMLA and the Analysis Services Execute DDL Task in SSIS to dynamically process just a required partition that has already been created in SQL Server Analysis Services (SSAS). I found that doing this in SSIS was a quick and easy way in order to get my data processed.
Read more...