title: How to get information from Excel files using SSIS
body: <p>I am new to SSIS and am trying to understand how to do the following:</p>
  
  <p>I have a folder (TestFolder) that has multiple folders within it (SubFolder1, SubFolder2, etc). In each subfolder there are multiple Excel files that have various names but will end in a date (Formatted as YYYYMM). In each Excel workbook there is a tab named: AccessRates and this is the data I want to store in the table in SQL Server.</p>
  
  <p>Okay, so the question: How do I set up my SSIS Control flow to handle such a task? I have built a Data Flow Task that handles the Data conversion, error handling and ultimate placement in the server table, but I can not figure out the Control Flow. I believe I need a ForEach loop container, but I can't figure out how to set it, along with the variables up.</p>
  
  <p>Any help or direction would be greatly appreciated!</p>
  
  <p>JP</p>