Home Forums Article Discussions Article Discussions by Author Discuss content posted by Craig Farrell SSIS OLEDB Destination Options RE: SSIS OLEDB Destination Options

  • January 19, 2012 at 7:42 am

    #1435853

    tofan.nayak (1/18/2012)

    Trigger always fire when SSIS load or insert in SQl Server Database label or table base trigger

    more.....

    http://blog.sqlauthority.com/2009/05/27/sql-server-interesting-observation-of-logon-trigger-on-all-servers/

    Not if you are doing bulk load. If you are doing bulk load, the default is to disable triggers. You can certainly turn them on, but you cannot say that they always fire.