Dtsrun command with nt authentication

• Joel Huffman

  SSC Journeyman

  Points: 78

  More actions

  July 17, 2003 at 6:47 am

  #106113

  Is there a way to execute the dtsrun command using NT authentication? I currently have an icon on a user desktop which runs a batch file that contains the dtsrun command and parameters (usercode and password for sql server authentication). This server uses nt authentication. Is it possible?

  Thanks

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  July 17, 2003 at 6:50 am

  #465834

  Use parameter /E to specifice a trusted connection (password not required).

  Make sure that user has sufficient permissions to execute the DTS package.