writing one row to multiple targets

[Anonymous]

how can I manage a case of writing one DB row to multiple targets using tmap ,and in case we have an exception in one of the targets, make a rollback to the others?

Thanks !

[vapukov]

You can use existing connection for all output components and onSubJobOk - tCommit, onSubJobError - tRollback

logic will be more complicated, but principles same

[Anonymous]

but this is for the whole input rows. what if I want to do this on only one row ?I don't want all rows to rollback , just the problematic one.

[vapukov]

---

@chenkosto wrote:
but this is for the whole input rows. what if I want to do this on only one row ?I don't want all rows to rollback , just the problematic one.

---

🙂 life is hard

seriously - check before insert for minimise exception, log errors, but never possible to do all what You want

of course You can process input row by row (iterate) ... but it take ages for finish ... or speed or ...

[Anonymous]

ok, how I do it with iterate?
can you send me a job description for example?