title: How to load specific Field in Excel with SSIS
body: <p>I have a Excel workbook with 2 Sheets: <code>testdata1</code> and <code>testdata2</code>. </p>
  
  <p>The data of a sheet looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/J4pWP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/J4pWP.png" alt="enter image description here"></a></p>
  
  <p>As you see, some column header like <code>average Test</code> and <code>sortnumber</code> are not on the same row with other column header ( <code>testvalue1</code>, <code>testvalue2</code>..)</p>
  
  <p>I want to load the data of Sheets <code>testdata1</code> and <code>testdata2</code> to a table in SQL Server. </p>
  
  <p><strong>Expected Output</strong></p>
  
  <p>The result I hope to see looks like this</p>
  
  <p><a href="https://i.stack.imgur.com/qlhCH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qlhCH.png" alt="enter image description here"></a></p>
  
  <p>Can you please help me how to do it?</p>
  
  <p><a href="https://www.dropbox.com/s/n2oflm3sai28y40/test%20SSIS.xlsx?dl=0" rel="nofollow noreferrer">excel data Link</a></p>