Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

Will trigger fire when inserting data through SSIS package?

Nice?Vote!

1 Answer

Nice?Vote!
 
Best answer
By default it wont.
To change thsi behaviour be have to follow following step:
In the data flow task, go to the Advanced Editor of OLEDB Destination, and there should be a property "FastLoadOptions". Specify FIRE_TRIGGERS as an additional option. That would cause it to fire triggers.
answered 1 year ago by R (19,530 points)

Related questions