all groups > sql server data warehouse > july 2004 >
You're in the

sql server data warehouse

group:

Incremental Update


Incremental Update Yash
7/19/2004 11:41:52 PM
sql server data warehouse:
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,
Re: Incremental Update Jéjé
7/20/2004 10:28:59 PM
search for the "process" method
you'll have some options in this method

I think there is a sample in the BOL

"Yash" <yash_chat@yahoo.com> a écrit dans le message de
news:053001c46e24$a3f0c5c0$a501280a@phx.gbl...
[quoted text, click to view]

Re: Incremental Update Dave Wickert [MSFT]
7/21/2004 11:33:44 AM
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]

Re: Incremental Update Yash
7/22/2004 1:01:39 AM
Hi Dave,
Thanks for this valuable information. I checked this one
out and this is the solution i was looking into.
Regards,
Yash

[quoted text, click to view]
FamilyID=a2eef773-6df7-4688-8211-
e02cf13cbdb4&DisplayLang=en
[quoted text, click to view]
Incremental Update anonymous NO[at]SPAM discussions.microsoft.com
7/25/2004 6:41:55 PM
you can run command line process from VB
[quoted text, click to view]
AddThis Social Bookmark Button