I'm trying to run a URL from a DTS that triggers a remote server operation.
I have the remote URL operational, it's just the DTS piece I need to
complete at this point. I'm not finding any pointers on how to run this on
MSDN or google. Any ideas?

Thank you,
-Steve

In message <#l7xgujTEHA.1412 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Steve Hebert
<steve (AT) hebertsoft (DOT) com> writes

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



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

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

I was debating about writing my own - but hoping for a built-in object. It
looks like ServerXMLHttp will do the trick.

Thank you!