I need to copy a file from one domain to another. The file is available in
https location and needs to be copied to a share location in a different
domain. How do I achieve this using DTS.
Does DTS support https connection.

Thanks
GS

I am using SQL Server 2000

Try this as a basis, just use https not http.

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
http://www.sqlis.com

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