title: How to validate data from flat file?
body: <p>I using script component for validating data more 50 columns. But it take more time. Any body give solution for this validation without third party tool in ssis. </p>
  
  <p>For example :</p>
  
  <p>I have validate dob column in following points</p>
  
  <ol>
  <li>Date format is correct or not.This my expecting format(mm/dd/yyyy).</li>
  <li>DOB not equal to empty.</li>
  <li>DOB value not greater than (12/31/9999).</li>
  <li>DOB value also check is date or not.</li>
  </ol>