Really nice article. I am newbie in this area.
Can I implement the same in my environment? here is the scenario.
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 ...can I use yours in my scenario? 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 you kindly suggest some method to my schenario?