title: SSIS Data Validation and Data Loading
body: <p>I need suggestion on best approach from below listed options. I need to validate excel file data and load it to SQL Server</p>
  
  <p>Validations include</p>
  
  <ul>
  <li>Non Duplicate columns</li>
  <li>Mandatoty fields present</li>
  <li>Fields not present in Database</li>
  </ul>
  
  <p>In case of error I would write in errorlog table in database</p>
  
  <p>Below is my approach</p>
  
  <ul>
  <li>Load the Data into a Temp Table in Database</li>
  <li>Run the Validations</li>
  <li>Log the Error</li>
  <li>On success load it to main tables</li>
  </ul>
  
  <p>Please let me know if you have any other better ideas for this scenario</p>