Hi ,
You need to give a more detailed explanation , including what is being read into Excel , where it is being stored , the format in which it is being stored , and give a few examples of the input data and the kind of validation you want ...
Narayan
Thanks,Hi ,
See if this link is helpful :
https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/
Narayan