title: Convert from DateTime to INT
body: <p>In my SSIS package, I have to converting values from DateTime to a corresponding INTEGER value. The following sample has been provided.</p>
  
  <p>Any ideas as to how I can convert these?</p>
  
  <pre><code>DATETIME   INT
  ---------  ----
  1/1/2009   39814
  2/1/2009   39845
  3/1/2009   39873
  4/1/2009   39904
  5/1/2009   39934
  6/1/2009   39965
  7/1/2009   39995
  8/1/2009   40026
  9/1/2009   40057
  10/1/2009  40087
  11/1/2009  40118
  12/1/2009  40148
  1/1/2010   40179
  2/1/2010   40210
  3/1/2010   40238
  4/1/2010   40269
  5/1/2010   40299
  6/1/2010   40330
  </code></pre>