Post reply

Use store procedurt in dts and rollback all step when store procedure fail

  • June 28, 2005 at 11:25 pm

    #60774

     

    I transfer data from Ids_Grn server to Wms_Grn server and Sms_Grn. And set line to rollback when step fail.

    If store procedute fail when I execute store procedure in  Execute SQL Task. It doesn't rollback all steps

    What should I do? 

  • June 29, 2005 at 12:33 am

    #569212

    Hi

    In DTS its not possible to rollback as it is not commited

    shashank

    Regards,

    Papillon

  • June 29, 2005 at 12:40 am

    #569213

    Set the transaction properties on the Advanced Tab of the Package Properties dialog.

    Check the workflow properties for the preceeding steps to make sure they "Join Transaction if Present" ticked.

     

    --------------------
    Colt 45 - the original point and click interface

  • June 30, 2005 at 1:00 am

    #569685

    Thank you very much. It success when

  • May 30, 2008 at 3:35 am

    #822172

    hello,

    clicking on "join transactions if present", we got the error message. so is there any prior criteria to click on it.

    Give Solution..

Viewing 5 posts - 1 through 4 (of 4 total)

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