insert/update into tables

pandujoy · Post by **pandujoy** » Fri Dec 11, 2009 2:22 pm

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

pandujoy · Post by **pandujoy** » Fri Dec 11, 2009 2:24 pm

Sorry forgot to mention i am using the odbc stages

ray.wurlod · Post by **ray.wurlod** » Fri Dec 11, 2009 3:03 pm

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

chulett · Post by **chulett** » Fri Dec 11, 2009 4:54 pm

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?