Not to fire a trigger when execute DTS

[jluost1]

How can I write an insert trigger that will not be fired when I import data via DTS package?

Or how can I tell sql server not to fire insert triggers when I import data via DTS package or DTS wizard?

Thanks.

 

[foxdev]

In your DTS package, add a SQL statement that disables the trigger via:

[tt]alter table ... disable trigger ...[/tt]

Don't forget to enable it at the end of the DTS job, or upon any failure point. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com