How to call a database procedure for each row and continue to a tMap?

[dstreun]

Challenge: I have to call a database procedure before processing each row (insert/update). The procedure sets a context (security, valid-as-of-date etc.) which is used by an instead-of trigger. - How can I do this?

I tried with a component sequence of a tFlowToIterate, a tDBSP and a tMap with several tDBOutputs. But such a sequence does not seem to work. A tLogRow instead of a tDBOutput shows that all attributes are null. - Probably, because tDBSP does not pass the values from the input row to the output row...

[manodwhb]

Hi, you need to iterate records using tflwtoiterate and then you need to use tdbsp component to execute the procedure.

[dstreun]

That's what I did - see my description. Does not help!

[dstreun · Accepted solution]

Finally, I found that I could use a tFixedFlowInput component to solve my issue.