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
OnProgressTSStep_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.

Can anyone explain what has gone wrong here.

We have a new server outside of our LAN and I have the exact same problem. I
can manually run the DTS package and it works, but it fails when ran by the
scheduler. I don't get that "OLEVERB" message, only the -2147221504(80040000)
message. I have looked high and low for a solution or even where to look at
what the problem is.
One guy said that he could get past his same problem by running the SQLAgent
using system account instead of a user account. I tried it and I still bomb.
I wish some log somewhere would tell what is causing this. It must be
security related but to where the problem is, who knows..

Ken

"Andre Gibson" wrote:

Cowlitz Ken wrote:

I'd suggest using a user accountr, and logging onto the server itself
with that account to execute the package.

INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/kb/q269074/)



--
Darren
http://www.sqldts.com
http://www.sqlis.com

Hello Darren,

I am using a domain account but yet still I am getting this error. Any ideas
for me

Andre

"Darren Green" wrote:

Hello everyone,

I don't know how proper this is but I found a resolution to my problem. The
account I was using had domain administrative rights. For some reason this
didn't work so I changed the set up and not sql server agent logs in using
the administrator username and password.

That seems to have resolved the issue. If anyone thinks this is wrong and
knows how to resolve it better please let me know because I thought domain
rights were good enough.

anyway thank for all of your input.

Andre

"Andre Gibson" wrote: