Code sample to create Analysis Services partitions in SSIS

Courtesy of Jamie Thomson, here’s some sample code showing how to create Analysis Services partitions from within an Integration Services package using AMO:

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

Although I should stress that if you’re using this in production, you do want to set the slice property on a partition to ensure you get the best possible performance in all cases.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: