What I need is to read each "FilePath" which is "Active" right now and then read the Excel files in that path. So I assume that I need at least 2 "For Each loop Container" inside each other. I've already done some part of the scenario :
Within the "Execute sql task" I'm retrieving "FilePath" which are active from the table and putting them in an "object" variable (My first variable in SSIS) .
Then I have my second variable in SSIS in which I keep the name of each "FilePath" each time the outer loop is being executed.
At the end I have my third variable which will change each time the inner loop in being executed and it carries the Excel files.
The outer loop must execute to the number of active rows in meta data table and the inner loop must execute to the number of file within the path.
The point is I receive no error after executing the package, but the data won't be inserted in my "OLEDB Destination" I was wondering if you could help me with this issue.