title: Compare two source and update sql server table in SSIS?
body: <p>I have excel source and sql server table .</p>
  
  <p>Excel Source column is </p>
  
  <pre><code> Mno    Price1  Price2
   111     10      20
   222     30      25
   333     40      30
   444      34      09
   555      23      abc 
  </code></pre>
  
  <p>Sql server Table </p>
  
  <p>Product table name</p>
  
  <pre><code>  PId    Mno    Sprice   BPrice
      1      111    3        50
      2      222    14        23
      3      444    32       34
      4      555    43       45  
      5      666    21       67 
  </code></pre>
  
  <p>I want to compare excel source Mno(Model number) with sql server Product table Mno (Model number), and if it is same i want to update Sql server Product table SPrice and Bprice. </p>
  
  <p>Please tell me what are the steps i want to do?</p>
  
  <p>I want to validate that excel sheet also, because in excel Price2 column have string values </p>
  
  <p>if it's string value i want to send mail which row data are wrong.</p>
  
  <p>I am new for SSIS so please give me details.</p>