Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Question Unanswered: Calling DTS from ASP through ISA Firewall

    I am trying to execute a DTS package from our external web site. The package resides on an SQL Server inside the ISA firewall. I can connect to the SQL Server via ADO but everything else is blocked so the following code will not work since I believe it uses Windows Integrated Security:

    Dim oPkg
    Dim objCID
    Dim objSID
    Dim objOrderID

    Set oPkg = CreateObject("DTS.Package")

    Set objCID = oPkg.GlobalVariables.New("@CID")
    Set objSID = oPkg.GlobalVariables.New("@SID")
    Set objOrderID = oPkg.GlobalVariables.New("@OrderID")

    oPkg.LoadFromSQLServer "ServerName", "UserName", "Password", , , , , "MSIOrder"

    objCID.Value = "2303"
    objSID.Value = "822105614"
    objOrderID.Value = "323"
    oPkg.GlobalVariables.Add objCID
    oPkg.GlobalVariables.Add objSID
    oPkg.GlobalVariables.Add objOrderID

    oPkg.Execute
    Set oPkg = Nothing

    Is there a way to call this DTS package via an ADO connection? And of course, to complicate things, I need to pass the DTS package three global variables.

    Lastly, modifying the ISA config is not an option unless I can be absolutely sure that it would not alter our current level of security.

    Thanks in advance,
    Jim
    Last edited by jmk_89513; 04-10-03 at 15:35.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    DTS? Ick. Anyway, are you sure you have the DTS DLLs installed on the client machine (this case the web server)? I believe you need to install Enterprise Manager on the machine for those DLLs to get installed. No separate installation as far as I know.

    Also, what error message are you getting?
    ~Matt

Posting Permissions

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