Hello All, I have a table that is filled up with data using a DTS. I have made a trigger for this table. The trigger is: CREATE TRIGGER tgrName ON [dbo].[table] FOR INSERT AS insert into table_audit select 'INSERT' AS [ACTION],GETDATE() AS ACTION_DT,* from Inserted When the DTS runs and fills with data the table, the trigger does not fire and the table_audit does not fills either. Can anyone help me? Thank you on advance
Are you using BULK INSERT in the DTS? Maybe the trigger isn't firing because it's a non-logged operation. I suspect this is the case, need to do some reading to check it out though.
I use a Transform Data Task. I went to the Properties > Option and unchecked the "Use fast load" tickbox. No the trigger is firing and everything seems OK. I don't know what this "Use fast load" does. I would appreciate if anyone could tell me. Thank you.
Thomas was right on issue, when you enable this option, the high-speed bulk-copy processing will be used and as per the design for non-logged operations the triggers will not be initiated.