If you are looking for a more complex example, see the Parallel Processing
Utility at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=a2eef773-6df7-4688-8211-e02cf13cbdb4&DisplayLang=en VB6 source is included in the kit.
Another (less-complex) way to do this would be create a DTS package which
does the processing you require using the DTS OLAP Processing task and then
invoke the DTS package from your VB program using the SHELL command and then
on the command line say something like:
"dtsrun xx.dts"
See BOL for how to use dtsrun.
The advantage here is that if the processing logic becomes more complex,
then all you need to do is modify the DTS package; not your application
code.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Yash" <yash_chat@yahoo.com> wrote in message
news:053001c46e24$a3f0c5c0$a501280a@phx.gbl...
> Hi All,
> Has anybody tried incrementally updatind a cube from a
> visual basic program. I am already doing it through DTS,
> but i need to know how to do through visual basic using
> the DSO.
> Many thanks,
> Yash