SQL Server Performance Forum – Threads Archive
Download file from Internet
Hi all, I’m being asked to create a scheduled DTS package that download a file from a http site, for example http:/www.problem.com/file.exe I’ve found solutions for this but when you have a FTP site. Any help will be appreciated! Thanks! Marcelahttp://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/6a0f200b10e61b8c/0d60f280eec4a73c?lnk=st&q=how+to+download+file+from+http+site&rnum=2&hl=en#0d60f280eec4a73c Read the above thread to get the answer… MohammedU.
Moderator
SQL-Server-Performance.com
Thanks!! I found another problem that was the proxy. This is the code I used to solve that. I hope it helps to anybody that have the same problem. Regards, ‘************************************************************************
‘ Visual Basic ActiveX Script"
‘************************************************************************
Function Main() Dim url, xmlhttp, responseBody
url = "http://www.iii.com.ar/file.exe"
Set xmlhttp = CreateObject("Msxml2.XMLHTTP.3.0")
xmlhttp.Open "GET", url, False, "userproxy", "passproxy"
xmlhttp.Send responseBody = xmlhttp.responseBody
Set xmlhttp = Nothing
Dim oADOStream
Set oADOStream = CreateObject("ADODB.Stream")
oADOStream.Type = 1 ‘(binary)
oADOStream.Mode = 3 ‘(read / write)
oADOStream.Open
oADOStream.Write responseBody
oADOStream.SaveToFile "c:somefile.zip"
oADOStream.Close
Set oADOStream = nothing Main = DTSTaskExecResult_Success
End Function
]]>