title: Validate data before uploading through SSIS
body: <p>I have a SSIS package to upload data from Excel file into an Sql Server 2005 table.</p>
  
  <p>The excel file will have varied lines of data ranging from 20k - 30k lines.</p>
  
  <p>The upload works fine, when all the data are correct.  But obviously fails when there is a small problem even in a single row. Examples like mandatory values presented null, inconvertable values (data type mismatch) etc.</p>
  
  <p>I want to validate the excel file before the upload and want to tell the user which row and column has got the error...</p>
  
  <p>Any idea as to how to accomplish this, without consuming much time and resources.</p>
  
  <p>Thanks</p>