TriggerNot working in DTS

Question

TriggerNot working in DTS

Geetha-245549

SSC Rookie

Points: 41
More actions
January 11, 2006 at 6:08 am

#111290

Hi,
I have have two databases A and B respectively. I'm using DTS to copy data from a table T1 in database A to table T2 in database B. Both T1 and T2 have the same schema. Table T2 has an insert trigger associated with it.
However, the DTS copy from T1 to T2 works fine but the trigger does not work on the data copy. The trigger however works fine if individual rows are inserted into table T2.
Can't figure out why this is happening. Doesn't DTS work internally by executing SQL statements, because I guess a trigger is applied on execution of a SQL statement. Any help in this regard would be appreciated.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

Geetha,

I assume you're using a Transform Data task to import the data. Look on the Options tab of the task properties and you'll see that Use Fast Load is checked. This specifies that bulk-copy will be used to load the data If you uncheck it the trigger will fire.

Because bulk-copy processing doesn't use individual INSERT statements, the trigger isn't fired. By unchecking the option, you're specifying that INSERT statements be used. The load will be slower, but the trigger fire.

Greg