execute multiple sql statements from .txt file using tflowtoiterate not writing to output

Anonymous — Tue, 30 Jul 2019 14:05:08 GMT

Hi,

I have a issue producing the output to tlogrows and the flow is as below.

i have 2 sql statments in the .txt file as below

query_id,query
1,select TOP 100 * from product
2,select TOP 200 * from product

All works fine but i dont see any result in the tlogrow and even i tried tfileoutputdelimted component also but no luck. Please can anyone help me.

Flow screenshot attached:

Thanks in advance.

Raghu

Re: execute multiple sql statements from .txt file using tflowtoiterate not writing to output

lennelei — Tue, 30 Jul 2019 16:51:52 GMT

Hi,

your screenshot seems to show that you're correctly retrieving 200 rows from the db component. Do you have the correct schema in this component and in the tLogRow ?

Regards.

topic execute multiple sql statements from .txt file using tflowtoiterate not writing to output in Talend Studio

execute multiple sql statements from .txt file using tflowtoiterate not writing to output

Re: execute multiple sql statements from .txt file using tflowtoiterate not writing to output