NB_LINE_INSERTED is null On Subjob?

[Anonymous]

I am trying to count the number of rows inserted during a job, but I can't seem to get a value from ((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_INSERTED")) other than null.

Any suggestions

[manodwhb]

Are you doing Insert operation in tdboutput?

[Anonymous]

The "Action on Data" is "Update or Insert". Is that an issue?

Edit: I tried changing it to "Insert" and that did not seem to have any affect. It still returns the following result.

[Anonymous · Accepted solution]

Thank you to anyone who took the time to look at this. I figured out the issue.

I was apparently using the tDBOutput component this whole time, and not the TMSSqlOutput component. As soon as I changed the tFixedFlowInput component value to ((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED")) It began to work!