Is it possible to execute a DTS package from a sproc or a trigger without
using sp_start_job? If so, how? I can't use sp_start_job since I'm not the
admin.

Thanks for any help.

Mary

you could use xp_cmdshell 'dtsrun...' assuming the non admin windows CMD
EXEC account has been enabled and has the necessary permissions.
Alternatively you could look at using the sp_OA stored procs that let you
create a OLE object, and use the DTS COM objects. Pretty nasty though ...

"Mary" <mary.powers (AT) pnl (DOT) gov> wrote

Have a look here

Execute a package from T-SQL
(http://www.sqldts.com/default.aspx?210)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mary" <mary.powers (AT) pnl (DOT) gov> wrote