When I use this task to load data into the table, why does the insert trigger not fire, do triggers not execute when you use DTS tasks . I know when we do bulk insert they do not execute, is it the same for DTS tasks. If not is there an option to fire the triggers?
Kavita