Rolling back the Transactions

• MuraliKrishnan1980

  SSCrazy

  Points: 2497

  More actions

  May 3, 2011 at 12:43 am

  #239399

  [font="Tahoma"]

  Hello Friends,

  I am having couple of dataflow tasks which insert values to tables.

  This is my requirement. If the second dataflow task fails, the inserted entries by the first dataflow task should be rolled back. Is there a way to do it? What should be the value for the Transactionoption property?

  Please help me on this.

  Thanks & Regards,

  Murali

  [/font]

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 3, 2011 at 6:49 am

  #1319013

  Check out the following link, I hope that it helps:

  http://www.mssqltips.com/tip.asp?tip=1585

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/