SQL Server >> SQL Trigger with DTS
There's an option in DTS to not use "fast load", or "bulk load" or what the option is names, Makes
DTS to do regular INSERTs. Will be slower, of course...
>I have a table that is updated via a DTS transform data task. This table has
> a trigger on it to perform additional tasks when data is inserted.
>
> When I manually insert into the table the trigger fires, but when the dts
> job inserts into the table it does not fire.
>
> Any ideas?
>
> Thanks,
>
> Mike
>
>
SQL Server actually have the option to fire triggers for bulk loading operations. But this is not
yet exposed in DTS. It is exposed in BCP and/or BULK INSERT, though...