How can I download Files form http: by DTS (not with
ftp) ??

There is nothing in the box that does http request, so how about an ActiveX
Script Task that calls a COM object capable of making the Http request for
you. There's a few around but I normally use ServerXmlHTTP

A quick example-

Dim xmlHTTP
Dim sURL

sURL = "http://someotherserver/respond.asp?Param1=" &
DTSGlobalVariables("MyVar").Value

Set xmlHTTP = CreateObject ("MSXML2.ServerXMLHTTP.4.0")
xmlHTTP.open "GET",, False
xmlHTTP.send ()
MsgBox xmlHTTP.responseXML.xml


You can write it to a file if you want, I just used a MsgBox for the demo.
ServerXmlHTTP is fully documented in the MSDN library, on or offline.


--
Darren Green
http://www.sqldts.com

"meo" <meyerjo (AT) sick (DOT) de> wrote