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

[Anonymous]

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

[lennelei]

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.