Anyone know how to have a DTS Datapump fire off a Trigger (stored procedure)? I have a trigger that will send off an email any time data is "inserted" into a table. However the method I use for insertion each day is a DTS package that transforms the data from the datawarehouse into my local app.
It seems that the datapump won't cause the insert trigger to fire
Any advice would be appreciated
Thanks in advance
tcg_gilbert (AT) hotmail (DOT) com

Have you removed "Use Fast Load" from the datapump options (final tab).



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"TCG_GILBERT" <tcg_gilbert (AT) hotmail (DOT) com> wrote

"inserted" into a table. However the method I use for insertion each day is
a DTS package that transforms the data from the datawarehouse into my local
app.