New answers tagged


With Scott Hodgin's help (see comment thread above), I was able to figure out the issue: First issue: Since I certainly was using an OLE DB destination, I needed to add FIRE_TRIGGERS in the Advanced Editor (Microsoft, make this easier to find) Second issue: once the INSERT trigger was firing, it was updating every record in the table, not just the ones ...

Top 50 recent answers are included