DTS Import wizard does not fire triggers

[SR]

Hi to all Gurus,

I am working with two tables, where in if a record is inserted in one
table an insert trigger fires and inserts relevant information for that
record in the second table. This works well within my applications.

But it failed (or the trigger never fired)when we used the DTS Import
wizard to insert new data into the table from an excel file.

How can I overcome this situation? Any help is greatly appreciated.

--Part-time BE

[Simon Hayes]

I believe (from memory - I may be wrong), that if you have "Use Fast
Load" checked on the Options tab, then triggers are disabled for the
load. So if you uncheck that box, they should fire. But on the other
hand, that will also disable constraint checking, which may not be what
you want either.

One (not very elegant) option would be to add an ExecuteSQL task to the
package, which does a zero-row INSERT after the data is loaded, just to
fire the trigger.

Simon