Post reply

Rolling back the Transactions

  • May 3, 2011 at 12:55 am

    #239401

    [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]

  • May 3, 2011 at 1:04 am

    #1318900

    I know SQL Server provide TRY...CATCH which implements error handling for Transact-SQL. Does it help?

  • May 3, 2011 at 2:02 am

    #1318916

    Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1102133-364-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 3, 2011 at 3:10 am

    #1318936

    [font="Tahoma"]

    Hello Gail,

    I am really sorry for posting the same topic in 2 forums. I did not get the intended reply. Hence i posted the same in this forum as well. Will refrain from doing this.

    Regards,

    Murali

    [/font]

    • Viewing 4 posts - 1 through 3 (of 3 total)

    You must be logged in to reply to this topic. Login to reply