Process OLAP cube via vbscript

Process OLAP cube via vbscript

Post by Sm9uIERlcm » Thu, 31 Aug 2006 01:34:03


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\MyCube1"
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
 
 
 

Process OLAP cube via vbscript

Post by Q2hhcmxlcy » Thu, 31 Aug 2006 02:36:02

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.yqcomputer.com/
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.yqcomputer.com/

 
 
 

Process OLAP cube via vbscript

Post by Sm9uIERlcm » Thu, 31 Aug 2006 16:51:02

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