 | |
DTS Import - Table Trigger
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS Import - Table Trigger -
12-16-2004
, 08:10 AM
#2
| |||
| |||
|
|
Hi, I have a (for insert, update) trigger on a table that get loaded with data through a dts package. The trigger calculates two fields together to update another field (checks and balances). When I update one record the trigger works but when the data gets inserted through the dts package the trigger does not fire. I am new with triggers and I do not know how to trouble shoot this situation. Thanks for any ideas. Art |
#3
| |||
| |||
|
|
-----Original Message----- It's a DTS issue. On the Options tab of the properties of your DataPump task, uncheck the checkbox that says "Use fast load".When you use fast load, triggers won't be fired. -- Jacco Schalkwijk SQL Server MVP "aplatfl" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0dca01c4e378$f97e6f50$a601280a (AT) phx (DOT) gbl... Hi, I have a (for insert, update) trigger on a table that get loaded with data through a dts package. The trigger calculates two fields together to update another field (checks and balances). When I update one record the trigger works but when the data gets inserted through the dts package the trigger does not fire. I am new with triggers and I do not know how to trouble shoot this situation. Thanks for any ideas. Art |
It works now.
Thanks you.
Art
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.