title: For Loop over Data/Rows from a DataSource/Select-Statement
body: <p>Here's the use case:
  Users enter the budget of each month. So there is a table with the fields [Year], [Month] and [BudgetValue]. </p>
  
  <p>Example: </p>
  
  <pre><code>2014  01  200'000.-
  2014  02  250'000.-
  </code></pre>
  
  <p>For each of those entries, I would like to select the working-day dates from my DimDate. For example, for January 2014 I would get 23 dates. (In my DimDate I have a bit which mark all the working days)</p>
  
  <p>In my actual FactBudget I would then insert a dayly budget with the 23 dates.</p>
  
  <p>Example: </p>
  
  <pre><code>2014.01.02   (200'000.-)/23
  2014.01.03   (200'000.-)/23
  etc.
  </code></pre>
  
  <p>I have no experience with the For/Foreach Loop Containers in SSIS. Is my problem even solvable with one of those containers or do I need a different structure/approach?</p>