Trigger and DTS

#1

Hi there,

The insert trigger that I created on a table does not
fire when I DTS data into the table. Is this by desgin
or is there a way/switch to make the trigger fire?
Please let me know if you have any ideas?

Thanks,
Danny

#2

On the last tab of the data pump turn off fast load

--
--

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

"Danny Mansour" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi there,

The insert trigger that I created on a table does not
fire when I DTS data into the table. Is this by desgin
or is there a way/switch to make the trigger fire?
Please let me know if you have any ideas?

Thanks,
Danny

#3

Thanks a million.

Quote:

-----Original Message-----
On the last tab of the data pump turn off fast load

--
--

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

"Danny Mansour" <anonymous (AT) discussions (DOT) microsoft.com
wrote in message
news:689001c3e6b3$8c9f4b10$a101280a (AT) phx (DOT) gbl...
Hi there,

The insert trigger that I created on a table does not
fire when I DTS data into the table. Is this by desgin
or is there a way/switch to make the trigger fire?
Please let me know if you have any ideas?

Thanks,
Danny

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Trigger and DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Trigger and DTS - 01-29-2004 , 04:02 PM

Re: Trigger and DTS - 01-29-2004 , 04:14 PM

Re: Trigger and DTS - 01-29-2004 , 05:02 PM