Hi all,
I had a DTS package running as a scheduled job that
processed some cubes. This was running fine until last
friday when somebody applied SP3a to both the AS and the
SQL server that it gets its data from. Previously both
were running under SP2.
Now the jobs never finish. They hang, and as I have to
terminate the job manually the DTS log never gets written,
so I do not know if it is one cube that is hanging, or if
the problem is just SP3 related. Anyone have any similar
experiences? The cubes are not particularly complex, ther
are no very large dimensions, but a job that used to take
roughly 4 hours now is still 'running' after 14 hours!!!

Any pointers appreciated.

It's likely a known issue since SP3, please contact MS PSS to verify the
problem and get the workaround or fix.

Thanks
Wei Zhang
Microsoft OLAP PSS
This posting is provided "AS IS" with no warranties, and confers no rights.

Sorry, MS PSS? I am afraid I don't know what you mean - I
assume thats some product support or something, but how do
I contact them?
I believe I have since 'fixed' the problem by recreating
the entire catalog of cubes from scratch. Not ideal.
Marc