Dtsrun -package execution across domain

• dtevlin

  Ten Centuries

  Points: 1084

  More actions

  June 1, 2005 at 11:48 pm

  #164509

  I am trying to create a batch file that uses dtsrun to execute a package which is on a different domain. The batch file code fails at to find the database (I am executing the code directly in a cmd window, and the machine I am executing from has the tools to do this). I think the problem is that it can't logon to the other domain, but I can't find a setting in BOL to allow me to do this.

  If I am on the same domain I have no trouble executing the package using the code below.

  Example code in batch file:

  dtsrun /SProduction_Server /Uusername /Ppassword /Ndtspackage

  I have tried using /UDomain2\Username to pass in the domain info but no go.

  Any ideas? Thanks.

• Glauco Costa

  Mr or Mrs. 500

  Points: 547

  More actions

  June 3, 2005 at 10:04 am

  #562969

  Try use "dtsrunui.exe", and see a command line who it execute.