{"id":175,"date":"2009-07-05T20:13:26","date_gmt":"2009-07-06T01:13:26","guid":{"rendered":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/?p=175"},"modified":"2009-07-05T20:13:26","modified_gmt":"2009-07-06T01:13:26","slug":"script-to-automate-ssas-partition-management-sql-ssis","status":"publish","type":"post","link":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/175_script-to-automate-ssas-partition-management-sql-ssis","title":{"rendered":"Script to automate SSAS partition management (SQL + SSIS)"},"content":{"rendered":"<p>Few years ago on my blog I posted scripts &#8220;<a href=\"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/13_ssis-package-to-dropcreate-partitions-based-on-partition-list-in-the-sql-server-table\" target=\"_blank\">SSIS Package to drop\/create partitions based on partition list in the SQL Server table<\/a>&#8221; and &#8220;<a href=\"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/11_ssis-package-that-process-all-partitionsmeasure-groupscubes-in-one-database\" target=\"_blank\">SSIS package that process all partitions\/measure groups\/cubes in one database<\/a>&#8220;. These posts contained partial scripts that I developed for company &#8220;<a href=\"http:\/\/insightdecision.com\" target=\"_blank\">Insight Decision Solutions Inc.<\/a>&#8221; to maintain partitions in the Microsoft SQL Server Analysis Services. This company sells, customizes and implements pre-packaged data warehouse solution (using SQL Server, SSAS, SSIS, SSRS, SharePoint and Excel 2007) for &#8220;Life&#8221; and &#8220;Health&#8221; insurance companies. Recently &#8220;Insight Decision Solutions Inc.&#8221; owners let me post full script on how to automate SSAS partition management . Here are step by step instructions that I adjusted and tested on Adventure Works database. Most of the code comes from my earlier published posts, here I just added information how everything works together.<\/p>\n<p><a href=\"http:\/\/www.ssas-info.com\/analysis-services-scripts\/1622-script-to-automate-ssas-partition-management-sql-ssis\" target=\"_blank\">Read more and download code here&#8230;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Few years ago on my blog I posted scripts &#8220;SSIS Package to drop\/create partitions based on partition list in the SQL Server table&#8221; and &#8220;SSIS package that process all partitions\/measure groups\/cubes in one database&#8221;. Here are step by step instructions that I adjusted and tested on Adventure Works database. Most of the code comes from my earlier published posts, here I just added information how everything works together.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,6,5],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/175"}],"collection":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/comments?post=175"}],"version-history":[{"count":1,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/175\/revisions"}],"predecessor-version":[{"id":176,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/175\/revisions\/176"}],"wp:attachment":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/media?parent=175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/categories?post=175"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/tags?post=175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}