June 14, 2008 at 3:18 am
We had created a cube which is in Analysis server.
this cube has to be processed on every weekend. we have to automate this cube through the SSIS . By using 'Analysis Services Processing Task' i tried to schedule the cube but i couldn't .
so pls can any give me the path how to config to Automate the cube .
Thanx
June 14, 2008 at 7:51 am
I assume you have created the SSIS package for processing the cube...this article talks about scheduling SSIS packages...
http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx
Hope this helps
Gethyn Elliswww.gethynellis.com
June 16, 2008 at 3:42 am
You can process a cube directly from the SQL Server Agent without the use of SSIS.
Add a step of type "SQL Server Analysis Services Command" and enter a XMLA Query to process the cube.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply