Post reply

xp_cmdshell

  • December 14, 2005 at 2:02 pm

    #90101

    I run this in cmd prompt: dtsrun /STest /Usa /Ptoy!22 /NPackage Test

    Successful but when I run this in QA:

    exec master.dbo.xp_cmdshell 'dtsrun /STest /Usa /Ptoy!22  /NPackage Test' - Failed

    DTSRun:  Loading...

    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

    NULL

    know why?

  • December 14, 2005 at 5:35 pm

    #609620

    Yes I know why.

    One of the connections in the package you're running can't access it's specified server. The big give away the message "[ DBNETLIB ] [ ConnectionOpen ( Connect ( ) ) . ] SQL Server does not exist or access denied."

    To fix the error you'll need to open the package in the designer and work out which step is failing then check the properties of the connection that step is using.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply