Friday, November 12, 2010

How to user SSIS to process SSAS Cubes Automatically

To Create SSIS And Schedule It

1. Create a New Integration Service Project. In the control flow tab, add a connection manager for analysis Services database and refer the instance of analysis service database in which cube exist.
2. From the Control Flow tool bar tab, find the ‘Analysis Services Processing Task’ and drag and drop to the control flow panel.
3. Edit this task and add the ‘cubes’ which we want to process in the object list option
4. Build the project and In the file menu, select ‘Save…..as’ and save the package to Analysis Services Database Server
5. Connect the Database Engine using Management Studio
6. Go to SQL Server Agent and Right Click on the Jobs. Add a new Job and set the Job Type as ‘integration Service’.
7. And Select the locally saved SSIS Package and set the period option as per your requirement
8. That’s it. Now the cubes will be processed at the scheduled intervals.

1 comment:

James Zicrov said...

Well, SSAS and SSIS can easily join and make up processes to solve each task step by step and dig out deeper to find out the best.

SSIS Postgresql Read