title: Converting a PeriodStart and PeriodEnd to year + week number
body: <p>I'm trying to convert a start + end date into multiple rows filled with weeknumbers and the year connected to it. My idea is to convert this start + end date in SSIS with a Script component, and create rows for each week by setting SynchronousInput to 'None'. I tried using a Timespan for this however this does not count through to the next year when reaching above week 53.</p>
  
  <p>Does anyone know how to accomplish this?</p>
  
  <p>Example: </p>
  
  <p>Input:</p>
  
  <pre><code>StartDate   EndDate
  2014-12-29  2015-02-01
  </code></pre>
  
  <p>Wanted output:</p>
  
  <pre><code>  Year  WeekNr
    2015      1
    2015      2
    2015      3
    2015      4
    2015      5
  </code></pre>