I have an SSIS package that runs my database load fine. However when
it gets to the last step where it is supposed to process the indicated
dimensions and cubes it always fails.

It appears to not process dimensions in sequence before processing the
cube depending on the dimension.

I just manually told it to process the entire OLAP database through
Analysis Services and it sailed through fine!

Any thoughts?

I'm thinking that instead of having one DTS task to process all the
cubes and dimensions that I should split it up into 2 tasks per cube
and thus insure that each dimension used by that cube is processed
before that cube is processed. This seems painful and something that
SSIS should handle automatically.

Also, I could use some help on capturing the log from SSIS regarding
cube processing.

Thanks,
Mel

you can use the profiler to see the exact xml/a command executed to process
the cubes.

also, you can create the process xml/a script and execute it instead-of
using the process task in SSIS, but the result is the same if the setup is
the same.

I'm using SSIS to process my cubes and I don't see any difference between
executing from SSIS or from any other method.

Do you use processfull or the processdefault method?

By default SSAS try to do an update of the dimension, this could cause
errors if you are using rigid links in your dimensions and if the data
changes for these attributes.

"Mel Suarez" <mel (AT) mlsuarez (DOT) com> wrote