Table data transfer using SSIS and triggers on destination table
If these triggers won't be fired while transferring data from source to destination table, is there anything can be done to fire these triggers during this data transfer?


In the OLEDB connection manager there are various options to load data. If


table or view using fast-load options is selected, then you have to explicitly specify FIRE_TRIGGERS in the advance editor as shown below :




If table or view data access mode is chosen then your triggers should fire normally because the insert is done row-by-row.