Does anyone know how to get a trigger to fire while you are uploading multiple records

• polo.csit

  SSCrazy

  Points: 2574

  More actions

  July 31, 2009 at 12:46 pm

  #212768

  Hello,

  Does anyone know how to get a trigger to fire while you are uploading multiple records into a SQL Server 2005 Express DB using the DTS Wizard?

  On insert of a person's record I want the trigger to find their id# from another table and update their information accordingly.

  I have the trigger built, but it will not fire when I use the DTS Wizard.

  Please help. Thanks.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 31, 2009 at 12:49 pm

  #1033119

  This is a duplicate thread. Please don't post the same question in multiple places on the site.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon