Post reply

RE:

  • June 28, 2005 at 11:22 pm

    #167313

    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? 

  • July 1, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • July 1, 2005 at 8:36 am

    #570349

    It isn't clear from the posting what you have set up and where the rollback is. Is the rollback in the stored procedure? Is this something you think should be happening in DTS? Some code might help as well.

  • July 1, 2005 at 11:15 pm

    #570485

    thank you everybody , finally I found the way that solve my problem.

     

    So, I am sorry about my picture that don't show anything. I don't know why.

    When I post reply and preview,it showed!!

     

    I am so sorry.

     

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

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