All,

I've written a DTS package that contains a complex VBScript that all works
fine but the problem is that I dont know how to fire this DTS package from
an INSERT trigger on a table (I specifically want to avoid a scheduled DTS
job in this case for performance).

I suppose the alternative would be to get the trigger to fire a stored proc
but then how can I execute a VBScript from a stored proc?

Any help (or alternative method if I'm barking up the wrong tree) would be
greatly appreciated.

Thanks,

Darbs....

Does this help

http://www.sqldts.com/default.aspx?219



"Darbs" <m_darbyshire (AT) hotmail (DOT) com> wrote

Thanks Allan,

That looks like it will do the job although 1 minor issue:- stored procs
sp_OACreate, sp_OAMethod and sp_OADestroy are not in master on my server
(SQL2000 sp4 enterprise) - is there a script somewhere that I can use to
create them???

Thanks,

Mark.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

They're not?

They should be AFAIK

Whilst only a sysadmin can execute them you should be able to see them



"Darbs" <m_darbyshire (AT) hotmail (DOT) com> wrote

I'ts me being stupid - I can't see for looking, thanks anyway!!

Mark.....

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote