title: SSIS: How to delete rows from a resultset before using the OLE DB Destination?
body: <p>I have a problem using the SSIS. I try to import data from database one to database two. Therefore I use a OLE DB Source with the following command:</p>
  
  <pre><code>SELECT Name, Description, JobID
  FROM   DBone.Table
  </code></pre>
  
  <p>My problem is, that I only want to import new data from this source. So I use a second OLE DB Source withe the following command:</p>
  
  <pre><code>SELECT JobID
  FROM   DBtwo.Table
  </code></pre>
  
  <p>Now I want to import only the data from database one, where the JobID is not in database two. So my idea was to use a Merge Join for the two data sources, so that my data looks like this.</p>
  
  <pre><code>Name | Description    | DBone.JobID | DBtwo.JobID
  -----------------------------------------------
  'One'| 'Little test.' |      4      |     4    
  'Two'| 'Little test.' |      6      |    NULL    
  </code></pre>
  
  <p>So I have the possibility to identify new data, because the column DBtwo.JobID is NULL. </p>
  
  <p>Now my question: How do I say SSIS to import only the data into database two where the DBtwo.JobID is NULL or to delete this data before import?</p>