HTTP request from DTS

#1

I want to make an HTTP request from a DTS task just to produce a log in an IIS
log file.
This I'm sure to have IIS log file processed by my DTS jobs.

How can I make such a task ?
ActiveX Script task ?

--
Kind regards / Cordialement

Sébastien MARSOLLE

#2

Use an ActiveX Script ask, or perhpas just use a job -

Set xmlHTTP = CreateObject ("MSXML2.ServerXMLHTTP.4.0")
xmlHTTP.open "GET","http://someotherserver/respond.asp", False
xmlHTTP.send ()

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

"S. MARSOLLE" <sebm (AT) nospam (DOT) fr> wrote

Quote:

I want to make an HTTP request from a DTS task just to produce a log in an
IIS
log file.
This I'm sure to have IIS log file processed by my DTS jobs.

How can I make such a task ?
ActiveX Script task ?

--
Kind regards / Cordialement

Sébastien MARSOLLE

#3

Darren Green wrote:

Quote:

Use an ActiveX Script ask, or perhpas just use a job -

Set xmlHTTP = CreateObject ("MSXML2.ServerXMLHTTP.4.0")
xmlHTTP.open "GET","http://someotherserver/respond.asp", False
xmlHTTP.send ()

Thank you, it works.

Quote:

"S. MARSOLLE" <sebm (AT) nospam (DOT) fr> wrote in message
news:uUfO6URCFHA.472 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
I want to make an HTTP request from a DTS task just to produce a log
in an IIS log file.
This I'm sure to have IIS log file processed by my DTS jobs.

How can I make such a task ?
ActiveX Script task ?

--
Kind regards / Cordialement

Sébastien MARSOLLE

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

HTTP request from DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

HTTP request from DTS - 02-02-2005 , 04:48 AM

Re: HTTP request from DTS - 02-02-2005 , 06:48 AM

Re: HTTP request from DTS - 02-02-2005 , 07:21 AM