title: How to compare two tables in SSIS? (SQL Server)
body: <p>I am creating an SSIS package that will compare two tables and then insert data in another table.</p>
  
  <p>Which tool shall I use for that? I tried to use "Conditional Split" but it looks like it only takes one table as input and not two.</p>
  
  <p>These are my tables:</p>
  
  <p><strong>TABLE1</strong></p>
  
  <p>ID<br>
  Status</p>
  
  <p><strong>TABLE2</strong></p>
  
  <p>ID<br>
  Status</p>
  
  <p><strong>TABLE3</strong></p>
  
  <p>ID<br>
  STatus</p>
  
  <p>I want to compare STATUS field in both tables. If Status in TABLE1 is "Pending" and in TABLE2 is "Open" then insert this record in TABLE3.</p>