title: SSIS Excel Source Metadata
body: <p>I have Excel source with these data:</p>
  
  <pre><code>Code
  5.43_P
  5.43_P
  5.43_P
  5.43_P
  5,31
  5,31
  5,31
  5,31
  </code></pre>
  
  <p>Now I want to load those data into table which has the structure:</p>
  
  <pre><code>CREATE TABLE X(
  Code nvarchar(10) null
  )
  </code></pre>
  
  <p>When I load the data from the Excel to this table destination (there are no transformation between the source and destination), the values "5.43_P" do not insert into table.</p>
  
  <p>When I check the metadata for the <code>Code</code> column from Excel source, it has data type <code>DT_R8</code> (float). </p>
  
  <p>What are my options now how to fix this? Can I change the metadata of the Excel source column so it loads all data into the table?</p>