MS SQL Server DTS - JOB fails immediately

Author

JOB fails immediately

Andre Gibson

2006-01-27, 1:23 pm

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_DTSTransferO
bjectsTask_1 DTSRun
OnProgress:DTSStep_D
TSTransferObjectsTas
k_1;
Scripting objects for Transfer;
PercentComplete = 0;
ProgressCount = 0
DTSRun OnError: DTSStep_DTSTransferO
bjectsTask_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.

Cowlitz Ken

2006-01-27, 8:24 pm

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:

> 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_DTSTransferO
bjectsTask_1 DTSRun
> OnProgress:DTSStep_D
TSTransferObjectsTas
k_1;
> Scripting objects for Transfer;
> PercentComplete = 0;
> ProgressCount = 0
> DTSRun OnError: DTSStep_DTSTransferO
bjectsTask_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.

Darren Green

2006-01-28, 7:23 am

Cowlitz Ken wrote:
> 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..
>

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

Andre Gibson

2006-01-30, 8:24 pm

Hello Darren,

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

Andre

"Darren Green" 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
>

Andre Gibson

2006-01-31, 9:23 am

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:
[color=darkred]
> Hello Darren,
>
> I am using a domain account but yet still I am getting this error. Any ideas
> for me
>
> Andre
>
> "Darren Green" wrote:
>

Sponsored Links