Scheduling a datacube to process (SQL Server 2005)

[StevenK]

I've been working with the SQL Server 2005 (and Management Studio tool) for some time now - but have yet to schedule the processing of a datacube through this.
How can I do this?

It used to be straightforward in SQL Server 2000 - but I can't seem to find my way in 2005.

Can anyone direct me to a tutorial or walkthrough for this please?

Thanks in advance.
Steve

 

[RiverGuy]

You can do it in Integration Services (SSIS). Here's an overview.

http://msdn.microsoft.com/en-us/library/ms141779.aspx.

If SSIS is unavailable, one method I used in the past was to create a simple program (in .Net in this case) to connect to the SSAS database and process the cube, which was scheduled to run in the Windows Task Scheduler.

 

[StevenK]

Thanks for the link. This looks to be an oviewview of what can be done.
Is there a tutorial that steps me through usage of this to achieve the required processing being scheduled?

Thanks again.
Steve

 

[RiverGuy]

Here's one:

http://msdn.microsoft.com/en-us/library/ms141701.aspx.

If this is the first time using SSIS, then you might want to look on MSDN or BOL for some overviews and tutorials of what SSIS is, different options to consider (for example, storing the packages on the file system or in the database), and issues to look out for.