Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    13

    Post Unanswered: DTSRun Fails while executing from COM

    Hi,
    i wrote a VB function that runs DTS by DTSRUN command, its working fine but when i copy the same code in COM and run it from ASP page and VB it fails to execute.


    Function ExeDTSRun(DTSName, mKey As String)
    Dim mDTS, spServerName, spUid, spPwd As String

    spUid = "sa"
    spPwd = "test"
    spServerName = "server"


    mDTS = "DTSRun /S " & spServerName & " /U " & spUid & " /P " & spPwd & " /N " & DTSName & " /G " & mKey & " /W ""0"""
    Shell mDTS, vbNormalFocus
    ExeDTSRun = "Successfully Run DTS : " & DTSName
    End Function


    Regards
    Adi

  2. #2
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63
    Do you get an error?

  3. #3
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    First guess: Does the account running the IIS thread have permission (NT permission) to execute DTSRUN.EXE. Also, if the DTS package is accessing resources other than on the local machine, you will need to grant permission for that as well.
    -bpd

Posting Permissions

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