"Andre Gibson" wrote:

> I have windows2000 server
> running sql server2000 sp4
> with sqlmail installed, configured, and working.
> Sql Server Agent is started using a dummy domain account with administrative
> rights for sql and the domain.
>
>
> I created a dts package that when manually run, works everytime. However
> when I try to schedule it, the job always consistantly fails in 1 second or
> less. Below is the message I got in the job log:
>
> Executed as user: FCPADM1\sqlmail.
>
> ...Start:
>
> DTSStep_DTSTransferObjectsTask_1 DTSRun
> OnProgress:DTSStep_DTSTransferObjectsTask_1;
> Scripting objects for Transfer;
> PercentComplete = 0;
> ProgressCount = 0
> DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147221504
> (80040000)
> Error string: Invalid OLEVERB structure
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts80.hlp
> Help context: 1100
> Error Detail Records:
> Error: -2147221504 (80040000);
> Provider Error: 0 (0)
> Error string: Invalid OLEVERB structure
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts80.hlp
> Help context: 1100
> Error: -2147221504 (80040000);
> Provider Error: 0 (0)
> Error string: Invalid OLEVERB structure
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts80.hlp
> Help context: 5700
>
> ... Process Exit Code 1.
> The step failed.
>