A strange thing happened on my server.
We are running a DTSX package that loads AS cube.
We were running for 2 hours with CPUs > 90%.
And then the CPUs on the machine fell down to 1-2%,
but job did not complete.

I do not have any error.
DTSX didn’t report anything.
SQL Agent thinks that job is running.
There is nothing from AS or DTSX in Events.
And I was running the Profiler (with Standard template) this time (this is
happening the second time) and I do not see anything in it.

Any ideas?

Dejan