dbTalk Databases Forums  

DTS Package for Incremental Builds of OLAP Cube

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Package for Incremental Builds of OLAP Cube in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kasp
 
Posts: n/a

Default DTS Package for Incremental Builds of OLAP Cube - 04-26-2004 , 07:55 AM






Hi,

I have a DTS package that loads new data into fact tables every evening. I
also have a OLAP cube which I need to incrementally build/update every
night.
The problem is that every time I execute the DTS package for cube update, I
get an Access Violation error or sometimes, the Enterprise manager just
crashes!
If I do a complete cube rebuild through DTS, it works properly.

I feel that the DTS package might be crashing if I don't have new data in my
fact table. How can I check for this?
Don't process cube if there is no data, but if there is new data...process
the cube incrementally.

I check Google groups for AV error with DTS, but couldn't find any answers.
Also, if anyone can point me to a good source for incrementally building
cubes with DTS, I will be obliged.

Thanks.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.