All,

i have a question with regards to DTSRUN. i have a package on my server
that is a hybrid from an example taken from
http://www.sqldts.com/default.aspx?246, which isn't my problem. this work
fine.

i want to set this up so that one of my users can fire this from her
machine. if i use dtsrun from the server it works fine but if i try to map
drives either using the pushd dos command or actual mapped drive it fails
with the following message. i have also tried to change the package
properties in the DTS package to no avail.


Y:\scripts>dtsrun /S"(local)" /E /N"bills"
DTSRun: Loading...

Error: -2147467259 (80004005); Provider Error: 17 (11)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exi
st or access denied.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0


Y:\scripts>popd

where Y:\ is the mapped drive of the server

please help!! or can somebody suggest a better way of allowing a user to
fire a job with out installing more software on their machine :-)

Many thanks
Simon Whale

Your DTSRUN command refers to the SQL Server (local). This does not make
sense, as the executable is running on the users machine, not the server, so
you need to specify the server name. This is just the server to load the
package from, so it needs to be server not the users machine.

Having the user call DTSRUN will mean the package executes on their machine
as well.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"news.microsoft.com" <simon (AT) nospam (DOT) ukdatait.com> wrote

Thanks Darren,
I also worked that out about 15 minutes before checking for replies, I have
changed this to the server name and now its not finding the files that I
move to the server;

DTSRun OnError: DTSStep_DTSActiveScriptTask_4, Error = -2147220482
(800403FE)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: File not found
Error on Line 25
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: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: File not found
Error on Line 25
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500

Would I need to change the paths in the package properties to mirror the
mapped drive?
Many thanks
Simon

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

sorry for all the question,

have worked it out, the directories for the files have to be on the local
machine

Many thanks
Simon
"news.microsoft.com" <simon (AT) nospam (DOT) ukdatait.com> wrote