title: SSIS: need to use SQL query results in other SQL queries for data
body: <p>I am trying to create an SSIS package for bringing over a subset of data into a separate reporting environment (basically from one data mart into another).</p>
  
  <p>There are multiple tables I need to bring data from, but there is 1 initial source table I use to filter the records which belong to my group.</p>
  
  <p>I am trying to figure out how to use the results from the first query as part of the subsequent queries. I have the first query returning just a single column (LookupID value) but it is going to have multiple rows.</p>
  
  <p>My goal was to have multiple data ODB Source/Destination packages (one for each table) using the LookupID values to just grab the relevant records for me. But I cannot seem to find a way to do that natively.</p>
  
  <p>My fall back is just to get all of the new records then delete within my staging tables but am hoping there is another/better method.</p>