dtsrun fails from remote server

• neal7

  Newbie

  Points: 5

  More actions

  June 25, 2007 at 4:05 pm

  #177205

  I have a DTS package that can be run from local packages.

  can also run locally with dtsrun;

  dtsrun /S g3 /E /N rem_report

  from another server with SQL client tools installed, I can run dtsrun on other packages ok, but not this particular pacakge. I get these errors;

  DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)

  Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

  I've also tried running this with the sa account, but still get the same results.

  I'm puzzled as to what the difference is from this package and other packages I've created. This package is running a query, then importing a csv file into a table.

  This process was working fine, until I was forced to install on a new server today.

  -at wits end,

  Mike

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  June 25, 2007 at 11:53 pm

  #715112

  See if you can make a client connection to the server mentioned in the package. If not create an alais and run the package that should work fine.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com