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. |