Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 triggers don't fire using DTS

Author  Topic 

nizmaylo
Constraint Violating Yak Guru

258 Posts

Posted - 2001-09-13 : 14:06:39
When using BULK INSERT I can specify FIRE_TRIGGERS option in order for the triggers other than insert triggers to fire. I recently used DTS to transfer the data and the triggers didn't fire. What shall I do diffrent while creating a DTS package to have the triggers fired?

helena
   

- Advertisement -