Extracting data from multiple tables to flat files.

[vvkprasad]

1. I have lot of different tables data to be extracted to flat files like table1, table2, table3.....tableXXX.

2. I need to run select * from each table and capturing the data in flat files by naming the file as table name.

I am trying to use foreach loop in the case but getting error...I captured table names (table1, table2 etc.,) and Query (select * from table1, select * from table2 etc., ) to a temp table and then using the variables tablename and query as variables in the foreach loop container and ending with error.

So my question is ... I heard some where that each table contains different columns and the each query leads to different columns and hence the columns are changing flatfile extraction is not possible. Is that correct?
Can anyone kindly suggest some method to my scenario?
Thanks in advance
Krishna.