SQL Server Performance

Triggers when inserting data with DTS

Discussion in 'SQL Server DTS-Related Questions' started by jilia, Sep 3, 2007.

  1. jilia New Member

    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

  2. thomas New Member

    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.
  3. jilia New Member

    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.
  4. satya Moderator

    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.

Share This Page