DSXchange

Hi ,

I am not sure how to go ahead with this issue...

I have 3 tables where i have to insert or update data into tables.

The problem i am having is if at all the job gets aborted due to the insert into the third table....can we roll back the trasaction (Insert) rows into first and second tables.

Appreciate your concern

Thanks

Sorry forgot to mention i am using the odbc stages

If you are using version 8.1 you can use a Distributed Transaction stage.

I'd be curious if you need to roll back the entire set of transactions made up to that point or just the most recent one? And could you use a Server job for this task?