dtsrun - on another users computer with out installing more software on the machine

06-01-2005, 12:46 news.microsoft.com

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

Re: dtsrun - on another users computer with out installing more software on the machine

06-01-2005, 13:08 Darren Green

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" wrote in message
news:eqKwM%23pZFHA.980@TK2MSFTNGP12.phx.gbl...
> 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
>
>

Re: dtsrun - on another users computer with out installing more software on the machine

06-01-2005, 13:32 news.microsoft.com

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" wrote in message
news:%23vnagLqZFHA.3096@TK2MSFTNGP15.phx.gbl...
> 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" wrote in message
> news:eqKwM%23pZFHA.980@TK2MSFTNGP12.phx.gbl...
>> 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
>>
>>
>
>

Re: dtsrun - on another users computer with out installing more software on the machine

06-01-2005, 13:58 news.microsoft.com

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" wrote in message
news:u4PaJYqZFHA.464@TK2MSFTNGP15.phx.gbl...
> 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" wrote in
> message news:%23vnagLqZFHA.3096@TK2MSFTNGP15.phx.gbl...
>> 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" wrote in message
>> news:eqKwM%23pZFHA.980@TK2MSFTNGP12.phx.gbl...
>>> 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
>>>
>>>
>>
>>
>
>