November 26th, 2003, 03:07 PM
SQL path structure
I run a SQL tool called DTSRUN. It allows me to reference a DTS package I have created, and successfully run it.
My goal is to give a user the ability to run this as well from her workstation. I have MS SQL loaded locally on my machine. It is located in:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn When I run DTSRUN, I must have a path built to this directory, since it runs without problems.
A user gets an error message with all sorts of "cannot find" and "invalid path" messages. I am not asking for MS SQL to be loaded onto her machine. I am asking what is the best way for a "User" to run a SQL command like this? Is there any way to "globally" supply the path to specific users?
November 30th, 2003, 11:14 PM
The answer is that she can not run DTSRun from her machine without installing the client tools for Sql Server. Even if the paths were not an issue you are still going to run into the issue of missing com objects on her machine. The only way to resolve this is to install the tools. Sorry
December 1st, 2003, 07:41 AM
Thank you, the information you provided was invaluable.