Hi,

I need to open a web page - so that I can mail a group of users
automatically - after a DTS has completed.

Is there a way of getting this done?

Thanks for any help,

NEIL

Hi Guys,

Thanks, I sorted it myself!











"Neil Jarman" <neil (AT) tNOiSPAMvPLEASEy (DOT) co.uk> wrote

Hi:

How were you able to do this? I am trying to figure out the same thing.

Thanks


"Neil Jarman" <neil (AT) tNOiSPAMvPLEASEy (DOT) co.uk> wrote

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

"Tarren" <noemailplease (AT) thanks (DOT) com> wrote

Hi Tarren,

I wrote a simple VB application which opened the required web page, then
waited a few seconds and then quit.

I called this from EM using a Execute Process task which I then scheduled.
It works perfectly!

If you don't have VB, mail me and I'll send you the necessary app and dll.

Neil