Hi,
Thanks for your reply. Looks like I didn’t articulate my problem correctly. I am using only one excel with multiple sheets and I am able to read all of them. First row of all the three sheets is the column header for the corresponding db table field names. When I try to insert using DB writer, I am able to insert the first sheet into the first table properly. But when the loop progresses, in the second iteration it fails. It takes the table name correctly (sheet two’s name - test2), as I have set it as a flow variable (table name -> Shee) but the column names are still showing table one’s column names. It’s not changing dynamically.
I’ve attached the excel and .knwf files for your reference.
Please help.
Thanks
Venkata