Re: Error in DTS - Object variable or With block variable not set

#1

Hi Lakshmanan,
Make sure you have set options Execute Pkg on Main Thread and Close
Connection on completion.
Is others things you need to keep eye on pkg as schedule like permissions
http://support.microsoft.com/default...;EN-US;Q269074
JFB

"Lakshmanan" <babulaksh (AT) rediffmail (DOT) com> wrote

Quote:

I have a DTS Package that contains a cube task to process
a virtual cube. When I execute the package it runs fine,
but the same when scheduled to run through Autosys(an
scheduling package from Computer Associates)i the log
show that the DTS package was invoked but gives the
following error:

Error Source: DSO
Error Description:Object variable or With block
variable not set
Error code: 800A005B
\Error Help File:
Error Help Context ID:1000091

Package Steps execution information:
Step 'DTSStep_DTSOlapProcess.Task_1' failed
Step Error Source: DSO
Step Error Description:Object variable or With block
variable not set
Step Error code: 800A005B
Step Error Help File:
Step Error Help Context ID:1000091

Step Execution Started: 7/16/2003 3:59:36 PM
Step Execution Completed: 7/16/2003 4:00:02 PM
Total Step Execution Time: 26.156 seconds
Progress count in Step: 0
Task Log for this step:

Thoughts/suggesitons will be appreciated.

Thanks in advance,
Lakshmanan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Error in DTS - Object variable or With block variable not set

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Error in DTS - Object variable or With block variable not set - 07-17-2003 , 03:28 PM