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.
| Author |
Topic |
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
 Posted - 2002-09-18 : 15:03:05
|
| How would I stop triggers from going off during a scheduled dts process? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-18 : 15:23:32
|
| I thought that DTS had a setting for triggers similar to BULK INSERT's FIRE_TRIGGERS, but I can't find it.Failing that, you can add an Execute SQL Task with the following:ALTER TABLE myTable DISABLE TRIGGER ALLAnd have this run before the data transform task(s). Then have a corresponding ENABLE statement in another Execute SQL Task after the transform completes. |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-09-18 : 18:08:28
|
| Thanks |
|
|
|
|
|
|
Stopping Triggers