Bertil Forsberg (10/22/2007)

---

Hi loi,

I think 'lomkar' is on an interesting track. Use SSIS to setup one 'parent flow', with TransactionOption='Required', and

10 child flows with TransactionOption='Supported'. Combine this with the technique...

Mike Bishop (10/11/2007)

---

Sounds like you might have to resort to a script task, using ADO.NET and the Ole db provider for Oracle. You would basically define a transaction, apply...