DTS Package remotely in batch file

Hello all,

I know others have posted for this topic (and i've read them all....),
but haven't read a surefire answer. So please bare with me....

I am trying to execute a DTS package in SQL 2000 on a server from a
remote client without SQL tools installed. I'm trying to get this to
run without the tools installed and from giving the user access to run
the package on the server. I've copied and registered the appropriate
dll's and rll's.

Batch file on client:
@ECHO OFF
"C:\WINDOWS\system\Resources\dtsrun.exe" /S "servername" /U "user" /P
"pw" /N "my package" /L

ECHO The execution of the DTS package has succeeded.
pause

Error generated by the DTS package:

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSCreateProcessTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421
(8004043B)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147220421 (8004043B); Provider Error: 0 (0)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147024875
(80070015)
Error string: The device is not ready.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147024875 (80070015); Provider Error: 0 (0)
Error string: The device is not ready.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100


Error: -2147024875 (80070015); Provider Error: 0 (0)
Error string: The device is not ready.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4900

DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1
DTSRun: Package execution complete.
The execution of the DTS package has succeeded.
Press any key to continue . . .

It seems that the DTS package is being kicked off, but every step in
the package is failing....

Please let me know if you need more info.

Thanks in advance!!!!

J

.

Relevant Pages

  • Re: DTS package runs, but not when started as job...
    ... I built a large DTS package to move some data into a database. ... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: ... Error source: Microsoft Data Transformation Services Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package ...
    (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: Scheduling a Job on a Locked Access DB
    ... I wrote a DTS package to import this data just after the data is ... DTSRun: Executing... ... Error source: Microsoft JET Database Engine ... Help file: ...
    (microsoft.public.sqlserver.dts)
  • 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)
  • dtsrun issues
    ... Created a DTS package and trying to run it from remote machine. ... DTSRun: Executing... ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)