Hello Everyone,

I would like to create a new cube by executing a VB Script created with the
Metadata Scripter and then process the new cube from within my VB application.

I am using the VB Shell command to execute the VB script via cscript.

Shell "cscript MSP_PORTFOLIO_ANALYZER.vbs"

As the Shell command causes cscript to run asynchronously, I need to somehow
wait for it to finish before I attempt to process my cube using DSO in my VB
application.

Is there a better way to do this?

Is there another way to run my VB script?

Is there a way to test and wait for completion of the VB script?

Any guidance would eb greatly appreciated...

Bob

Bob Segrest, PMP
BSegE LLC
(540) 937-5875
http://www.BSegE.com

DTS is good for this kind of precedence. You can have VB Script steps in
your DTS package, and then have the cube processing as the last step in your
package. You can set workflows between these steps so that the cube build
doesn't run until your VB script is complete.

"Bob Segrest" wrote:

Sounds like a reasonable approach...

But I haven't used DTS before, can you provide me with an example or a
pointer?


Bob Segrest, PMP
BSegE LLC
(540) 937-5875
http://www.BSegE.com