Re: DTS package runs, but not when started as job...

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

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

Allan

"murrayb3024" <murrayb3024@xxxxxxxxx> wrote in message news:1131644038.755152.274400@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

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.


.

Relevant Pages

  • DTS Package remotely in batch file
    ... the package on the server. ... ECHO The execution of the DTS package has succeeded. ... DTSRun: Executing... ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: DTSRUN privileges?
    ... be aware that the DTS package runs on same ... machine as DTSRUN. ... client machine and have specified SQL Server name 'local' in the DTS ... The DTS package is stored in the database. ...
    (comp.databases.ms-sqlserver)
  • Re: Difference when running a DTS package
    ... When they run DTSRun they use the /s switch to indicate the server, and the /e switch to use integrated security. ... switch to specify the server where the DTS package will execute. ... and som users execute the package with DTSRun run locally. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTSrun
    ... And the package worked. ... it seems that> dtsrun generates a string that does not work but I am unsure why at this> juncture. ... Any DTS package saved with an owner password>> fails ...
    (microsoft.public.sqlserver.dts)
  • DTS issue on SQL 2k
    ... I am getting the following error when I try to run the DTS package ... DTSStep_DTSActiveScriptTask_2 DTSRun OnError: ... Microsoft Data Transformation Services Package Help file: ...
    (microsoft.public.sqlserver.dts)