Hi All, Many Thanks in Advance.

We are attempting to use the following code to execute an asp page from a
sql dts. The problem is the with the xmlServerHttp.send() line we are
receiving a connection with the server cannot be made. Is there either a
simple error in the code or a better way of doing this?

Cheers - Rossco

Function Main()
Dim xmlServerHttp

Set xmlServerHttp = CreateObject("Msxml2.ServerXMLHTTP.4.0")


xmlServerHttp.SetOption 2, 13056 ' Ignore all SSL errors
xmlServerHttp.open "POST",
"https://10.20.16.40/faws/taxivoucher/tv_email_form.asp", False
xmlServerHttp.setRequestHeader "Content-Type", "text/html"

'error comes when it attempts to send
xmlServerHttp.send ()



Set objStream = CreateObject("ADODB.Stream")
objStream.Type = 1
objStream.Open
objStream.Write xmlServerHttp.ResponseBody
objStream.SaveToFile "C:\NY.ZIP", 2
Set xmlServerHttp = Nothing
Set objStream = Nothing
Main = DTSTaskExecResult_Success

End Function

"Rossco" <Rossco (AT) discussions (DOT) microsoft.com> wrote

I'm assuming that if you paste that URL into a browser on the machine
running the DTS package that the page loads fine. If that is the case,
check the proxy settings for getting to the target server; you may have to
run proxycfg to get the proxy settings correct.

thanks,
mark

Have you tried to use just

Server.CreateObject("Msxml2.ServerXMLHTTP") ?

*** Sent via Developersdex http://www.developersdex.com ***