title: Importing excel files having variable headers
body: <p>I have the SSIS package, which will load the excel file into Database. I have created Excel Source task to map the excel column name to Database table column name and its working fine.</p>
  
  <p>In rare case, We are receiving the excel file column name with some space <em>(for example : Column name is "ABC" but we are receiving "ABC ")</em> and which cause the mapping issue and SSIS got failed.</p>
  
  <p>Is there any possible to trim the column name without opening the excel.</p>
  
  <p><em>Note : Page name will be dynamic and Column position may change (eg: Column "ABC may exist in first row or second row or ..").</em></p>