Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    England
    Posts
    152

    Unanswered: DTSrun permissions

    Hi

    We are attempting to run a dtsrun statement remotely, via a stored procedure. We are getting the errors below, although I have ran this from a c: prompt on my PC.

    C:\>dtsrun /SNT_LAKES02 /Usa /P---- /Nbmmenudev /Ap_menucode:8=101

    DTSRun: Loading...
    DTSRun: Executing...
    DTSRun OnStart: DTSStep_DTSDataPumpTask_1
    DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
    Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
    Error source: Microsoft OLE DB Provider for SQL Server
    Help file:
    Help context: 0

    Error Detail Records:

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

    DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
    DTSRun: Package execution complete.

    We have also tried this with the /E option with the same results.

    Can anyone offer any help - thanks in advance
    Regards
    Dbabren

  2. #2
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    ......

    exec master..xp_cmdshell 'dtsrun /SNT_LAKES02 /Usa /P'


    well you most likely will need to have permissions to exec master..xp_cmdshell. This most likely is the root of you problems, that is what was my issue when doing this for the first time.

Posting Permissions

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