How to get dynamic schema for queries

[Anonymous]

Hi,

I have a file where it has list of queries that generate different schemas. I would like to iterate this file and execute each query and write to excel file. Schema for each query has to be generated dynamically. 

tFileInputExcel-->tFlowTolerate-->iterate-->tDBInput-->tfileOutputExcel

Can any one help me out?

Thanks in advance,

Meghana.

[root]

What do you need to write back to the excel file?

You can use this component to execute the statements on a db.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

HTH

[Anonymous]

I am using input excel to read list of queries to execute and the output excel is to store the result of each query.

[root]

Kool. The component I shared with an help execute your listed queries

[Anonymous]

I cannot see tSQLScriptParser

[root]

Its supposed to be downloaded from the Talend MarketPlace. I use this daily. 

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...