#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    21
    Rep Power
    0

    Question 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?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    NY
    Posts
    18
    Rep Power
    0
    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

    -- Messorian
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    21
    Rep Power
    0

    Talking THANKS =)


    Thank you, the information you provided was invaluable.

IMN logo majestic logo threadwatch logo seochat tools logo