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

Hello tiv,

So you have registered the dlls though right because the way you are executing
it here the package will come to you. The fact you say /S is immaterial
as this is a storage location. Have you enabled logging in the package?


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

the /S switch is needed to specify the server where the package resides
doesn't it? After a bit more testing and poking around, i have a hunch
it is a connection issue and not permissions. It finds the package,
executes it, then fails at the first step. Is there a way of testing
the connections within the package?

The package connects to AS400 and pulls data into SQL db on the server.
I've also mirrored the ODBC conns on the server to my local laptop
running the batch file.

I have enabled logging, but it just goes through ever step and says
"was not executed".

Allan Mitchell wrote:

Hello tiv,

Yes /S finds the storage location server but that is it. The package does
not necessarily execute there. It executes on the callers PC. This does
still sound to me like a resourcing issue or permissions


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Hey Allan,

Little by little, I'm getting further. I had to fix a UNC path in the
first step of the package from the drive letter on the server. Also
found I've had to add some ODBC connections on the local laptop. Some
steps are completing now, others have failed on the connection, so i'm
thinking the ODBC connections will fix that. Haven't gotten a chance
to test yet....but I'm hopeful!

Thanks again!


Allan Mitchell wrote: