You mention that the trigger on table1 is not working when you use DTS. There is an option called "use fast load" under the options tab on the transformation data task properties dialog. If you uncheck this you should find that your trigger now fires properly when using DTS.
Thanks,
Jeff
|