Fire triggers when rows are being inserted by sqlbulkcopy RRS feed

  • Question

  • I am using sqlbulkcopy to insert bulk data into the sql database. But sometimes I may get duplicate values at that time I have to update than inserting a new data. I wrote insert triggers to to this task. But while using sql bulk copy class, it triggers only once after inserting all the rows. so duplicate occurs. Anybody help me in this? I have to fire my insert trigger everytime the row is being inserted.
    Thursday, June 16, 2011 5:35 AM

All replies