Hi,

I need to find out how to process an AS 2000 cube via vbscript.

So far I have set the following properties:

' *** Set Task Properties
oOLAPTaskProperties("Description").Value = "Process MyCube"
oOLAPTaskProperties("Datasource").Value = "MyDatasource"
oOLAPTaskProperties("TreeKey").Value =
"MYSERVER\MYSERVER_AS\CubeFolder\MyCube\MyCube 1"
oOLAPTaskProperties("FactTable").Value = "dbo.MyTable"

But how do I now process the Cube?

I've tried "oOLAPTask.Execute" but it doesn't seem to like it???

I've found it very difficult to find any help...

Thanks in advance

Jon Derbyshire

Does it have to be vbscript rather than vb 6? You could save yourself a lot
of trouble by creating whatever you want to do as a package in the DTS
Designer, and saving it to Visual Basic. This will create your package code
in VB with the correct data typing. You just need to add references that
point to the DTS libraries. You could then execute it from a VB app, or
compile it into a DLL, and then calling the DLL from a vbscript.

Hope this helps.

Charles Kangai, MCT, MCDBA

Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm






"Jon Derbyshire" wrote:

Hi,

As requested, I'm looking to do process the cube via vbscript "inside" my DTS.

I don't agree with spreading code everywhere just because its easier to code.

Any help would be great.

Thanks

Jon Derbyshire

"Charles Kangai" wrote: