title: How to avoid NULL values in database table using SSIS package creation?
body: <p>I'm using SQL Server Business Intelligence Development studio - > Integration Service project</p>
  
  <p>My Task is use Excel file as input source . insert the excel sheet values to DB [Destination source] table [SQL 2008]</p>
  
  <p>My Excel Format [I'm using MS-Office 2013]</p>
  
  <pre><code> ID|Tier|TierType|Age|Count
   ==========================
   1   4             18  0.652
   2   4    EV           2.569
   3   5    EG       25  1.035
   .   .    .         .   .
   .   .    .         .   .
   .   .    .         .   .
  800  4    EE       40  1.526
  </code></pre>
  
  <h2> My DB Table Design</h2>
  
  <pre><code>Tier    - int
  TierType- varchar(5)
  Age     - int
  Count   - float
  </code></pre>
  
  <h2>Table output.</h2>
  
  <pre><code>ID|Tier|TierType|Age|Count
  ==========================
  1   4    NULL     18   0.652
  2   4    EV       NULL 2.569
  3   5    EG       25   1.035
  .   .    .         .   .
  .   .    .         .   .
  .   .    .         .   .
  800 4    EE       40  1.526
  </code></pre>
  
  <p>I'm able to insert excel sheet values insert into DB table successfully.</p>
  
  <p>My problem Is</p>
  
  <p>In excel sheet First 8 records are empty from 9 records onwards values present sample below:-</p>
  
  <pre><code>ID|Tier|TierType|Age|Count
  ==========================
  1  
  2
  3
  4
  5
  6
  7
  8
  9  4      EE     20   0.256
  </code></pre>
  
  <p>If first 8 records are empty remaining values also display null for (int[Tier,Age],float[Count]) in DB table.Varchar values Display correctly</p>
  
  <h2>Table output.</h2>
  
  <pre><code>ID|Tier|TierType|Age|Count
  ==========================
  1   NULL  NULL   NULL  NULL 
  2   NULL  NULL   NULL  NULL 
  3   NULL  NULL   NULL  NULL 
  4   NULL  NULL   NULL  NULL 
  5   NULL  NULL   NULL  NULL 
  6   NULL  NULL   NULL  NULL 
  7   NULL  NULL   NULL  NULL 
  8   NULL  NULL   NULL  NULL 
  9   NULL  EE     NULL  NULL 
  .
  .
  .
  800 NULL  EC     NULL  NULL
  </code></pre>
  
  <p>please tell it's Default problem or i made mistake in creating package.</p>