Hi,

What is this 1000091?

Is there anyone know how to solve the error shown below.

Executed as user: SQL01\Administrator. ... 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 OnError:
DTSStep_DTSOlapProcess.Task_2, 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: D... Process Exit Code 2.
The step failed.

Thanks,
Siong.

Hi,
My exprience is no more two processing at the same time in a DTS package.
If you must do that, try Microsoft Parallel Process Utility.

http://www.microsoft.com/downloads/d...DisplayLang=en


"Siong" <Siong (AT) discussions (DOT) microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:494C7085-0973-44C9-A163-3269BC38D799 (AT) microsoft (DOT) com...
Hi,

What is this 1000091?

Is there anyone know how to solve the error shown below.

Executed as user: SQL01\Administrator. ... 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 OnError:
DTSStep_DTSOlapProcess.Task_2, 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: D... Process Exit Code 2.
The step failed.

Thanks,
Siong.