title: SSIS load validation
body: <p>I'm importing data from a text file using Bulk Insert in the script component in SSIS package.</p>
  
  <p>Package Ran successfully and data imported into SQL</p>
  
  <p>Now how do I validate the completeness of the data?
  1. I can get the row count from source and destination and compare.
  but my manager wants to know how we can verify all the data has come a cross as it is  without any issues.  </p>
  
  <p>If we are comparing 2 tables then probably a joining them on all fields and see anything missing out. </p>
  
  <p>I’m not sure how to compare a text file and a sql table. 
  One way I could is write code to ready the file line by line and query the database for that record and compare each and every field. We have millions of records so this is not going to be a simple task. </p>
  
  <p>Any other way to validate all of the data ??</p>
  
  <p>Any suggestions would be much appreciated</p>
  
  <p>Thanks
  Ned</p>