Geek asks and answers

How to create / delete a cube partition through SSIS

I cannot find a good tutorial that could link me how to create / delete a cube partition using SSIS tasks.

This is the first time I do this, in fact I am also new to SSAS. So the tutorial I found is

Creating a Cube Partition Using Script Task

Analysis Service Run DDL Task

I also saw the analysis service processing task , but I'm not sure if it can perform the same task or not.

I need to run my package every month to create a new cube partition based on variables.

Which method would be best and recommended to make a cube partition through SSIS?

I want to create a new section and delete the old section based on the condition.

PS . I used to be a .NET developer, so the Script task is the best option, after which I can go for it.

Any suggestions?

+3
source share
1 answer

One way is to create a template section for each measure group in your cube. Using the SSIS script task, you can access the section of the template through AMO (analysis management objects), clone it, modify it where necessary (for example, the initial request) and save it in your database.

Example: http://consultingblogs.emc.com/jamiethomson/archive/2008/09/15/ssis-create-analysis-services-partitions-from-a-ssis-package.aspx

+2
source

More articles:


All Articles