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 |
|
augustin_p
Starting Member
21 Posts |
 Posted - 2002-04-25 : 04:58:53
|
| Im trying to port data from an existing database (SQL Server 7.0) into an another SQL Server database with different table structures. The new database haas triggers that has to be executed when data is inserted into specific tables. triggers aer not getting invoked when data is inserted using DTS. can't triggers be invoked when inserting records into the table using DTS.Thanks,prasanna |
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-04-25 : 07:10:10
|
| I'm not completely certain but I believe that, depending on the way you are using DTS to transfer data, it might be a non-logged operation. Regardless, if the updates happen as a batch, keep in mind that triggers only execute once, which means that if multiple records are affected the trigger will not work for all them, unless they are "inserted" one at a time, then the trigger will fire.Kyle HeonPixelMEDIA, Inc.Programmer L2kheon@pixelmedia.comEdited by - KHeon on 04/25/2002 07:10:52 |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-25 : 10:32:28
|
| On the advanced tab of your Data Pump Data Transformation Properties, try setting the Insert Commit Size to 1 and Unchecking the "Use Fast Load" checkbox. This will slow down your load, but I think it will envoke the triggers.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
DTS & Triggers