Results 1 to 2 of 2

Thread: password

  1. #1
    Join Date
    Oct 2003

    Unanswered: password

    I have a DTS saved as a structered storage file.How can I provide SQL SERVER Logon ID and password for this DTS package and call it within a SP through the LOGON ID and Password?

  2. #2
    Join Date
    Oct 2003


    exec master..xp_cmdshell 'dtsrun /Ssql1 /NPublish /E'
    --This will execute the DTSRun command line utility with the parameters

    /S = SQL Server Host Name
    /N = DTS Package Name
    You can either use /E for "trusted connection" or /U/P to supply username and passwords

    You will need the correct permissions to run xp_cmdshell since it is in the MASTER database.

Posting Permissions

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