SSIS Dynamic population of Excel File Name

Question

I've written an SSIS package to upload data from an Excel source to a OLE DB Destination - however when I wish to use a ForeachLoop container in order to load data from multiple excel files I am getting an error. I have followed the tutorial contained in the link below:

https://msdn.microsoft.com/en-us/library/ms345182.aspx

All of the configurations are correct apart from the Variable strFileName which needs to be dynamically populated. As can be seen from the screen shot below my variable remains blank:

I am unsure how to do this. Is there an expression or function that can be used to dynamically populate this variable?

Answer 1

If you want stored fileName dynamically for each one in your folder use the Variable Mappings in your loop like this

Mapping

And for your loop:

ForEach

Note that your variable is always blank because the field is only updated when you enter in your loop.