SSAS Articles 
AMO SSIS: Create Analysis Services partitions from a SSIS package
AMO SSIS: Create Analysis Services partitions from a SSIS package
| SSIS: Create Analysis Services partitions from a SSIS package |
| Written by Jamie Thomson |
| Monday, 15 September 2008 22:43 |
|
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: Read more...
|
Tags: 2005, amo, article, partition, ssis
Latest Author Articles
All articles by Jamie ThomsonTop Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
