DSXchange

You are correct, bulk loading or splitting into separate stages is not an option for us (unless we can somehow ensure Transaction Grouping). That is, if we perform an update then an insert, yet the insert fails, the previous update must not take effect. We do not have failures often, however if we d...

Thanks Ogmios, what strategy did you ultimately implement when you encountered this problem?

Assumming we can put up with committing after every pair, does anybody know how/why this insert is committing prior to the update failing?

Thanks for the responses. Was using a colleagues logon when I originally posted whilst getting my login sorted out. I don't want to commit after each record, I want to commit after the entire process has completed. Therefore if either of the streams fails, rollback everything. You are right, array s...