title: SSIS not importing TEXT column from Excel correctly (integer results in NULL value)
body: <p>I have Excel 2003 files which are imported through SSIS into SQL 2008 R2. With one of the columns I hit a big problem. The column is defined as TEXT in the Excel sheet. Out of 36 rows 32 are having values like XTZ23, they get import correctly. The last 4 rows however
  are just numbers like 2646672. They are imported as NULL. If I change the connection String to IMEX=1 and modify the registry to <code>TypeGuessRow=0</code> these numbers end up like 2.64667e+006. </p>
  
  <p>What did I miss here? </p>