title: SSIS to copy data from one table to another, where not in destination table
body: <p>I'm in the process of creating an SSIS package on a server (server1) that looks at the data in a sql db on another site (server2) and copies relevant rows across.</p>
  
  <p>The SQL statement required is:</p>
  
  <pre><code>SELECT *
  FROM server2.ordersTable
  WHERE
  OrderID Not In (SELECT OrderID FROM server1.ordersTable
  </code></pre>
  
  <p>This selects data from server1 which isn't in the table on server2 (based on order id)
  I then need to insert the result into a table on server1</p>
  
  <p>How would I approach this? What components do I need etc...?</p>