I need to be able to allow a non-technical user to kick off a DTS job
whenever she needs to. Is there a way to call a DTS job from the command
line, or a stored procedure that I can call from a web page? Any help would
be greatly appreciated.

In message <edVh45Z8DHA.1636 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Maria
<test (AT) test (DOT) com> writes
For simple command line stuff lookup DTSRUN in Books Online.

Some other methods-

Execution
(http://www.sqldts.com/Default.aspx?104)


Remember that DTS is client side so you may not want the use running the
packages directly as this will run on their machine under their security
context, so some abstraction layer would probably be called for.

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

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