read sql query from table and execute it

[karandama2006]

Hi ,

I'm working on a use case , we have some SQL queries inserted in a table and I want to read the SQL queries from the table row by row and execute them.
Then take the output and insert it in some table.

Wanted some help in getting started with this use case , which components to use ? what would be the flow?  

Thanks,

Karan

[manodwhb · Accepted solution]

@karandama2006 , check the below screenshot and below link.

tRun Job

https://community.talend.com/t5/Design-and-Development/Passing-a-value-from-a-parent-Job-to-a-child-...

[karandama2006]

Thank you very much , exactly what I wanted