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?
You can use existing connection for all output components and onSubJobOk - tCommit, onSubJobError - tRollback
logic will be more complicated, but principles same
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 ...