title: How do I configure a foreach loop container in SSIS to take defined start and end dates and run for each date in between?
body: <p>I'd like to define <code>start_date</code> and <code>end_date</code> parameters in my SSIS package, and have a <code>foreach</code> container that runs for each date in between these 2 (inclusive), which executes a SQL query taking in the current date value (ie starting at <code>start_date</code>) and using it as a parameter for the query.</p>
  
  <p>I'm quite new to SSIS programming and I cannot find information on how to do this.</p>