Any idea on this error message?

The job can fail with this message...I re-run it a minute later and it works
OK. The underlying data has not changed either. It just happens once in a
while.


Executed as user: Jesse\svc_db. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1 DTSRun OnError:
DTSStep_DTSOlapProcess.Task_1, Error = -2146828197 (800A005B) Error
string: Object variable or With block variable not set Error source:
DSO Help file: Help context: 1000091 Error Detail Records:
Error: 0 (0); Provider Error: 0 (0) Error string: Object variable or
With block variable not set Error source: DSO Help file:
Help context: 1000091 DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_2 DTSRun OnFinish:
DTSStep_DTSOlapProcess.Task_2 DTSRun OnStart:
DTSStep_DTSOlapProcess.Task_3 DTSRun OnFinish:
DTSStep_DTSOlapProcess.Task_3 DTSRun OnStart:
DTSStep_DTSOlapProcess.Task_4 DTSRun OnFinish:
DTSStep_DTSOlapProcess.Task_4 DTSRun: Package execution complete.
Process Exit Code 1. The step failed.

Well, it appears your first DTS task: DTSStep_DTSOlapProcess.Task_1

potentially has some VBScript in it and the object is not being set properly
or is losing focus. Are you by any chance in this task processing alot of
dimensions or cubes? e.g. doing a for loop around the dimension objects and
processing each within that for loop?

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>
space: http://spaces.msn.com/members/denster/



"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

This can happen if you are processing Analysis Services objects in parallel
using DTS. Look at this KB article to see if it fits:
http://support.microsoft.com/kb/870620/

Dean.

"Jesse O" wrote: