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