We recently had a fire on campus. So we had to move all our data to new
servers. The servers are supposed to be identical. I built a large DTS
package to move some data into a database. I also made it a scheduled
job, and a vb app that calls the scheduled job so our end users can run
it by themselves. It was working fine in the previous servers. Now, if
I run the DTS package, it works fine. If I try to run the Scheduled Job
through Enterprise Manager or through the VB app it fails. Here is the
error I get:

Executed as user: server\user. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error
string: ActiveX Scripting encountered a Run Time Error during the
execution of the script. Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error
Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0)
Error string: ActiveX Scripting encountered a Run Time Error during the
execution of the script. Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.


I am not sure why it will work if the DTS package is started by me, but
not through the scheduled job. I have been working on this for days and
I really don't know what else to try, any help would be GREATLY
appreciated.

In 99.5% of the cases the answer can be found in this article

http://support.microsoft.com/?kbid=269074

Allan

"murrayb3024" <murrayb3024 (AT) gmail (DOT) com> wrote

Unless I missed something, I am not sure that is my problem. The owner
of the Job is a Domain Admin account, and I couldn't find
SQLAgentCmdExec in the error I got. I do notice that it is trying to
use a local machine account to run it though and this is what I cannot
figure out how to change. I don't think I saw that anywhere in the
article. Did I miss that?

So the job owner is a sysadmin. The user that executes the package then
is the account under which the agent service runs.

Allan

"murrayb3024" <murrayb3024 (AT) gmail (DOT) com> wrote

That would be my account, and I am an Admin. How can I use the
sp_update_job to rename the owner? Or would that not be any differnent
then changing the owner in the dropdown?

The dropdown works

"murrayb3024" <murrayb3024 (AT) gmail (DOT) com> wrote

So I guess this is what is confusing me, the owner is set to me (Domain
Admin), I start the scheduled job, and it fails when trying to get data
off another server. I am set up in the security on the share on the
other server. This all works if I just manually start the DTS package,
but fails everytime on the scheduled job.

And under what account does the SQL Server Agent run?

"murrayb3024" <murrayb3024 (AT) gmail (DOT) com> wrote

How can I check that?

You can either go to the services applet OR
Right click the SQL Server Agent node in EM and choose properties.
Should be on the first tab.

Allan

"murrayb3024" <murrayb3024 (AT) gmail (DOT) com> wrote