Hi,

I'm trying to execute a script on our web server, a PHP script, using
"Execute Process Task" task in DTS designer.

So far, I'm able to execute it but it seems like it does not return anything
one the page is loaded.

Tried using a timeout, to kill the page after 60 seconds, but since the PHP
script performs sql operations, this timeout won't always
be sufficient.

I also tried printing a window.close(), to close the window after processing
is done, but this only brings up a dialog, notifying me that this window
wants to close. This also does not work.

Please anyone out there.

In message <ufP72WRhEHA.712 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Wikus Schalkwyk
<wikus (AT) experient (DOT) co.za> writes
I don't understand how you can use the Exec Process Task to call a web
page.

If I wanted to call a web page and post data or retrieve the page
content I would do this from an ActiveX Script using a suitable Http
capable component, such as the MSXML.ServerXMLHTTP component.

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

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