I think the problem here lies with the fact that your package is probably
set to use bulk inserts when running the data transformation task. These
are nonlogged operations which will not cause triggers to fire.
There is an option for each transformation to turn of the bulk insert
loading. It can be found on the Options tab of the Data Transform Task
properties dialog box. Deselct the Fast Load option. Also, check that the
Select Into/Bulk Copy option is not active on the destination database.
Hopefully this will cure the problem.
However, this may be an inefficient way of doing things, especially for
large uploads. It may be better to append an Exec SQL Task to the DTS
package containing code that will mimic the trigger but will work on the
whole batch. This will only be practical assuming you have some way of
identifying the new records.
> I Have a DTS that copies one file txt to a Table.
> That table as a Trigger for insert.
> When i insert one line by hand, the trigger fires, but with DTS he never
> What Can i do??
Please help me with the following problem
I have a package inserting rows from a text file to a table in a database.
The table has trigger stoping from inserting special records, but it is
ignored when i insert records with DTS.
What can i do to make my trigger function also in case i insert records