Is there a way to have DTS open an internet browser
window and then save the file to a temporary location on
the local hard drive?

In message <e50101c3f0e4$2611b410$a301280a (AT) phx (DOT) gbl>, SR
<anonymous (AT) discussions (DOT) microsoft.com> writes
No, and you really wouldn't want to automate IE.

Use a component to do this through code only. Here is some VBScript that
doesn't do what you want, but should be a pointer-


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

It uses the ServerXMLHTTP class from MS XML 4 to handle the http
connection. Get the MSXML SDK (help file) or search MSDN for full
details of ServerXMLHTTP.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org