I want to run a DTS/SSIS package from web but we do not want a full web

server on the SQL box to do this but still the ability to run the
DTS/SSIS package from a HTTP connection.

Please advice.


Thanks
Karen

Hello KarenM,

Do you want SSIS or DTS?

DTS just use the dlls on the webserver (or call a job)

http://www.sqldts.com/default.aspx?225
http://www.sqldts.com/default.aspx?207
http://www.sqldev.net/dts/ExecutePac...isual%20Csharp


SSIS install the SSIS service from the install media.





Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Hi Allan,

Many thanks for the tip. But I do not want to run from a web server I
want to have a cut down HTTP server that can only run a DTS package my
sysadmins are not letting me run a web server on the SQL box and I
cannot put the SQL client on a machine that is a web server. So I want
to build a custom HTTP Server that can only run a DTS package specified
still callable from a URL almost like a web service but I do not want
to make it too fancy.

Thanks
Karen
Allan Mitchell wrote:

Hello KarenM,

Wherever requests the package to be run will need the DTS dlls. You could
fire a job which executes the package in which case the job server is running
the package.


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com