SSIS Package to process all dimensions in one SSAS Database

Written by Vidas Matelis. Posted in SSAS Scripts

Some time ago in my blog (http://www.ssas-info.com/VidasMatelisBlog/?p=8) I described how to create SSIS package that process all dimensions in one Microsoft SQL Server Analysis Services 2005 database.

Here you can download package that does this processing.

Use it at your own risk.

Note: If in script editor you see blue underline for Microsoft.AnalysisServices definitions, then you have to copy Microsoft.AnalysisServices.dll to the .NET folder.
Default location from: C:\Program Files\Microsoft SQL Server\90\sdk\Assemblies\Microsoft.AnalysisServices.DLL
Default location to: C:\WINDOWS\Microsoft.NET\Framework\v2.0.?\

Tags: process, ssis, script