Triggers when using DTS

• Shark Energy

  SSCrazy Eights

  Points: 8389

  More actions

  April 4, 2008 at 6:57 am

  #70904

  Hi,

  I understand that using a data pump via DTS will not fire triggers on the destination tables ala bcp. But if I run a stored proc or piece of sql within a dts package, that should kick of the triggers shouldn't it?

• Shamshad Ali

  SSCarpal Tunnel

  Points: 4822

  More actions

  April 4, 2008 at 7:45 am

  #798444

  Yes, sure you can do that...

  Open the transformation task (the black arrow) properties. On the last tab (Options) there's a "use fast load" checkbox. Try unchecking that.

  http://channel9.msdn.com/ShowPost.aspx?PostID=80260