Results 1 to 8 of 8

Thread: DTS Fails

  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: DTS Fails

    Good Morning,

    I've been running into a small problem. There are two people that usually create local packages to be executed by the DTS. Either my boss or I. The problem that I have been running into is, there are some local packages that will not execute when I try to run them. These packages are that my boss has created. When she runs them they work fine. But when I run them they just don't run. The only way I can run the local package is if I log in into the server and run it from there.

    The error that I keep getting is:

    Unspecified Error
    [Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified.

    What would I be able to do so that I can execute this local package from my computer?

  2. #2
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    Could try changing the owner of the DTS package.

    Have a look at the following link and tell me if it helps your situation.

    http://www.sqldts.com/?212

  3. #3
    Join Date
    Mar 2004
    Location
    West London
    Posts
    34

    Question

    What is the package doing exactly. Is it accessing an odbc datasource and if so do you have this set up locally?

  4. #4
    Join Date
    Jan 2004
    Posts
    164
    It is accessing a datasource, and it has been set up on my machine. We use the same data source to import information. I am able to run other DTS that have been created by her, but I am not successful at executing all of them.


    I did go to the link listed by aldo_2003 and there was some helpful information. So if I am not apart of the sysadmin group, then that can be a reason for me not being able to execute the local package? Cause like i said, when I log on the our server, I am able to execute the package just fine. Just not from my machine.
    Last edited by estefex; 04-15-04 at 11:21.

  5. #5
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    You need to be either ower or part of sysadmin to execute the package to run.

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Otherwise what you can do is open the query analyzer, connect to the remote server and EXECUTE master.dbo.xp_cmdshell 'dtsrun /S (local) /U {uid} /P {password} /N {name dts package}'

    With this you can see whether the package executes well or not.

    If you wish to schedule this package on the remote server you need to modify the DTSrun on each step from the schedule as well.
    Modify the dts to read the same: dtsrun /S (local) /U etc.... via the Tab Steps and the button Edit
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Jan 2004
    Posts
    164
    Thank you very much for all your help. I was listed as a sysadmin, but there were a few drivers that I had to add to my user dsn. That was the whole reason why I was getting the error. Everything works fine now.

  8. #8
    Join Date
    Jan 2004
    Posts
    164
    This is how I did this.

    control panel -> administrative tools -> Data Sources -> User DSN -> Add -> Select Driver -> Finish

    Then you will be prompted to type in the Data Source, Host, and Port.

    Then you should be able to run the local package.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •