title: SSIS lookup transform alternatives?
body: <p>I need to transfer about 11 million rows daily from one database to another. The source table is about a half a billion rows total at this point.</p>
  
  <p>I was using the "get everything since ?" method, using the max in the destination as the ?, but the maintenance of the source is kind of funky. They keep going back to fill holes and my method isn't working.</p>
  
  <p>The standard Lookup transform takes hours to run. Pragmatic's TaskFactory has an Upsert component, but it's not in this project's budget.</p>
  
  <p>Is there a better way than Lookup to lookup?</p>