I am working with the tMSSqlSP component and I have no problems getting and parsing the results. Yet, because of that those results need to be parsed to XML I need a scenario where I can look how many results there were returned and I need to create a 0 results scenario. I am aware of the global variable NB_LINE, but does this exist for the component tMSSqlSP?
Solved! Go to Solution.
There is no global variable like (Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_UPDATED") available if you use tMSsqlSP to call the stored procedure.
If you want to count the number of rows are deleted, inserted or updated, you have to use tMSsqlOutput to do it.