Post reply

task rollback

  • August 30, 2016 at 8:02 pm

    #400653

    hi

    i have four execute sql task in my package.

    what i need to do if any of the task fails,example task3 then all other task that executed before should be rolled back.

    how to do in ssis?

  • August 31, 2016 at 3:09 am

    #1898478

    You need to include all of these tasks in a Sequence container. This will process each task in a "transaction". If one fails, you can set up SSIS to roll back the process.

    Setting it up is little move complex than "just putting them inside the container", but that should get on you the right track.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 31, 2016 at 3:25 am

    #1898482

    thanks a lot

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

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