Report Portal

SSIS: Create Analysis Services partitions from a SSIS package

I have recently been working on a project implementation that incorporated SQL Server Analysis Services (SSAS) and there was a requirement to be able to create partitions on-the-fly from our ETL process running on SQL Server Integration Services (SSIS). I looked into using XML for Analysis (XMLA) to do this but after some trial and error decided to go with the Analysis Management Objects (AMO) object model instead which can be called from a SSIS Script Task. I built a parameterizable SSIS package that could be called from anywhere in our ETL process and thought it would be useful to share - hence this blog entry.

Some points you should note about this code before you try and use it:



Tags: partition, amo, ssis


2007-2015 VidasSoft Systems Inc.