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:
Set oPkg = CreateObject("DTS.Package")
Set objCID = oPkg.GlobalVariables.New("@CID")
Set objSID = oPkg.GlobalVariables.New("@SID")
Set objOrderID = oPkg.GlobalVariables.New("@OrderID")
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.