Post reply

SSIS and Insert Triggers

  • December 23, 2009 at 3:37 am

    #136957

    Hi

    I have a table which has triggers that fire if a particular column is populated. I have tested the trigger by inserting data via sql statements and it works fine. The problem arises when I use SSIS to import the data form Excel. the data is successfully imported but the triggers is not fired.

    Any Ideas

  • December 23, 2009 at 7:48 am

    #1095920

    Try this:

    Go to the Advanced Editor of the OLEDB destination task under Component Properties there is a property called 'FastLoadOption' add FIRE_TRIGGERS in that property.

    -Vikas Bindra

  • December 24, 2009 at 3:13 am

    #1096272

    Thanks Vikas

    Thats has done the trick!

  • December 24, 2009 at 3:20 am

    #1096275

    You are welcome.

    -Vikas Bindra

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply