Automaiicly Refresh a Cube 1

[TimK01]

Using SQL Server 7 (and im new to it) I have created a DTS package to build the Data Warehouse and I can see how to refresh that, but it seems reasonable to to automaticly refresh the cube too, but I cant see how to. Can anyone help?

 

[mhweiss]

In SQL Server 2000 there is a DTS package type that processes a cube...I dont know if SQL Server 7.0 has this but I think it is new to SQL Server 2000. If you cant migrate to SQL Server 2000, you might have to use DSO (Decision Support Objects) and write code to refresh or process the cube....
Try searching Books On Line for DSO...
hth,
Michael

 

[TimK01]

Thanks Michael

I dont see any cube objects available in SQL Server 7 DTS.

So if anyone has any other ideas or Code fragnments that would be realy helpfull.

Tim

 

[mhweiss]

Tim,
Search MSDN and the MS Knowledge Base...there is an add in available for DTS 7.0 (SQL Server 7.0)...it contains a package object for updating and processing OLAP cubes
hth,
Michael
PS -
If I get a chance, I will search for it myself and post the url here...

 

[TimK01]

Thanks again Michael
the download is Data Transformation Services Task Kit 1 available from DOwnloads on the SQL Server site

 

[mhweiss]

That is the one...I just happened to come across it the other day by accident actually...let me know how it works for you, Tim.
~Michael

 

[TimK01]

Works great, Thanks again Michael