Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 incrementally updating cubes

Author  Topic 

Devarajan
Starting Member

13 Posts

Posted - 2004-07-05 : 00:45:58
I am loading data into my data warehouse every day and i did this using the SCHEDULING THE DTS PACKAGE and then i want my cubes also to
be updated as soon as my data warehouse is updated by my DTS package
is there any option in SQL server to do this


G.Devarajan
S/o K.Gopalakrishnan

Devarajan
Starting Member

13 Posts

Posted - 2004-07-07 : 07:21:39
plz somebody help me in this

G.Devarajan
S/o K.Gopalakrishnan
Go to Top of Page

jojo_jacob
Starting Member

24 Posts

Posted - 2004-07-07 : 07:29:04
You can add 'Analysis Services Processing Task' in the DTS package to do this.
Go to Top of Page

Devarajan
Starting Member

13 Posts

Posted - 2004-07-09 : 00:21:25
Thanks for ur reply we have finished already

G.Devarajan
S/o K.Gopalakrishnan
Go to Top of Page
   

- Advertisement -