Post reply

Managing rollback

  • April 27, 2004 at 4:04 am

    #59256

    Hello all,

    We need to rollback a (third party created) DTP package that is called via dtsrun.

    Is it possible to roll the entire sequence of operations back and essentially wrap it all in a transaction block ?

    From my experience of using dts this seems unlikely given the fact that each step is executed sequentially. If a step fails that can be rolled back but any preceding steps are already committed.

    We cannot change the dts package as that would invalidate support but we can look to rewrite it in TSQL.

    Any help appreciated.

    TIA

    cheers

    dbgeezer

  • April 28, 2004 at 8:16 am

    #504514

    Each step has an rollback transaction under workflow properties. If you check this in  all steps it should rollback the dts pkg.

    Regards

    JFB

  • April 28, 2004 at 8:47 am

    #504520

    thanks

     

    found the same solution elswhere.

    cheers

    dbgeezer

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

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