Dynamically reading Schema From a table

[ShastriV]

I have a requirement where i need to read schema of 7 Views from MSSQL dynamically and output all columns into csv Files. What is the best way to achieve this? Please suggest

Thanks

[manodwhb]

@vineela shastri​ , first lets have details of view queries and data details.

1) using tfiexedflowinput lets have column like query and use tFlowtoIterate

2) from tFlowtoIterate connect to tDBinput and pass global variable of query in tDBinput

3) in tDBinput have single coulmn with dynamic data type and connect to tfileoutputdelimitted and you can have the file as against view from tfiexedflowinput

Thanks,

Manohar