title: How to delete rows based on comparison from Data Flow Task in an SSIS?
body: <p>I have a DataFlow task with two OLE DB Source objects. This is the SQL I want to achieve using SSIS:</p>
  
  <pre><code>Insert into server2.db.dbo.[table2] (...)
  Select col1, col2, col3 ...
  from Server1.db.dbo.[table1] where [table1.col1] not in 
  (Select col5 from server2.db.dbo.[table2] Where ...)
  </code></pre>
  
  <p>I am pretty new to SSIS and not sure how to achieve this. I thought I could do this using the Data Flow task and populating the first source with the data from server1.db.dbo.table1 and the second source with server2.db.dbo.[table2] and then do the conditional check before inserting it into server2.db.dbo.[table2]. I am not sure how to do the conditional check though. Any help is appreciated. </p>