Excel Source Plus

[Mike]

Hi, 

I am using "Excel source plus." However, my excel file is dynamic. I used the "Foreach Loop container" to get the file name. How can I configure the WorkSheet name? The sheet name will not change, but I want to pull the data from the second sheet. If I hard code and read one file, it works. When I use "Variable" in Excel source plus connection string, it will error out, and the error is sheet name doesn't exist. 

Any advice?

[Ivan Peev]

Hi Aqeel,

Starting from 2.0 version, you can reference a sheet by index like that :1