title: Importing data from Excel in SSIS, empty values
body: <p>I'm using SSIS to import data from Excel sheets into SQL Server 2005, the data contains some columns with data that should have the value of the previous non-empty cell in the same column, it looks like this:</p>
  
  <pre><code>2005 | 15 | Something1
       | 12 | Something2
       | 14 | Something3
  2006 | 10 | Something4
       |  2 | Something5
       | 18 | Something6
       | 15 | Something7
  </code></pre>
  
  <p>It should fill-in 2005 and 2006, but all I could get is nulls.
  Can I put this field's value in a variable if it's not null, and use it to replace the null values that come after it?</p>