Hi, I have included FIRE_TRIGGERS in fast load mode and my package is failing with error "An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back"
Package is succeeded if FIRE_TRIGGERS is removed.
I have tried inserting one record manually and the trigger functionality is working fine.
Can someone shed light if there is any other setting that needs to be updated in order to fire triggers using OLE DB destination component. Much appreciated.