Managing SQL Analysis Service Objects with SSIS and AMO

One of the really cool things about SQL Server Analysis Services 2005 is the ability to examine and dynamically manage its objects (cubes, measure groups, dimensions etc). Using the Analysis Management Objects (AMO) model you can interact with Analysis Services objects - manage and manipulate them using simple code. I currently use this method to manage very large OLAP cubes in the organisation I work for. Combined with the functionalities provided by SQL Server Integration Services (SSIS) I have found you can be extremely creative in the way you administer your OLAP solutions.

Read more... (Requires SQLServerCentral registration)