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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.