Trigger Insert VIA DTS

#1

Hi All.

I have an insert trigger into a table, but when I insert data using a DTS,
the trigger is not shot.

If I insert data manually, trigger works sucessfuly.

There's any way to make trigger works using a DTS??

thansk for your help.

#2

Turn off fast load on the DataPump.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"DeMoN" <d_rodriguez_rincon (AT) yahoo (DOT) es> wrote

Quote:

Hi All.

I have an insert trigger into a table, but when I insert data using a DTS,
the trigger is not shot.

If I insert data manually, trigger works sucessfuly.

There's any way to make trigger works using a DTS??

thansk for your help.

#3

Thanks Darren.

I have codified a new approach, to avoid the use of the trigger.

Regards.

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Quote:

Turn off fast load on the DataPump.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"DeMoN" <d_rodriguez_rincon (AT) yahoo (DOT) es> wrote in message
news:%23PQgyIpDFHA.1012 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Hi All.

I have an insert trigger into a table, but when I insert data using a
DTS,
the trigger is not shot.

If I insert data manually, trigger works sucessfuly.

There's any way to make trigger works using a DTS??

thansk for your help.

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

Trigger Insert VIA DTS

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

Trigger Insert VIA DTS - 02-09-2005 , 04:29 AM

Re: Trigger Insert VIA DTS - 02-10-2005 , 09:07 AM

Re: Trigger Insert VIA DTS - 02-14-2005 , 05:13 AM