 <p>You will need to identify what makes that data unique in the table. If it's a customer table, then it's probably the customerid of 13029. However if it's a customer order table, then maybe it's the combination of CustomerId and OrderDate (and maybe not, I have placed two unique orders on the same date). You will know the answer to that based on your table's design.</p> <p>Armed with that knowledge, you will want to write a query to pull back the keys from the target table <code>SELECT CO.CustomerId, CO.OrderId FROM dbo.CustomerOrder CO</code> If you know the process only transfers data from the current year, add a filter to the above query to restrict the number of rows returned. The reason for this is memory conservation-you want SSIS to run fast, don't bring back extraneous columns or rows it will never need.</p> <p>Inside your dataflow, add a <a href="http://msdn.microsoft.com/en-us/library/ms141821.aspx" rel="nofollow">Lookup Transformation</a> with that query. You don't specify 2005, 2008 or 2012 as your SSIS version and they have different behaviours associated with the Lookup Transformation. Generally speaking, what you are looking to do is identify the unmatched rows. By definition, unmatched means they don't exist in the target database so those are the rows that are <em>new</em>. 2005 assumes every row is going to match or it errors. You will need to click the Configure Error Output... button and select "Redirect Rows". 2008+ has an option under "Specify how to handle rows with no matching entries" and there you'll want "Redirect rows to no match output."</p> <p>Now take the No match output branch (2008+) or the error output branch (2005) and plumb that into your destination.</p> <p>What this approach doesn't cover is detecting and handling when the source system reports $56.82 and the target system has $22.38 (updates). If you need to handle that, then you need to look at some change detection system. Look at Andy Leonard's <a href="http://www.sqlservercentral.com/articles/Stairway+Series/76390/" rel="nofollow">Stairway to Integration Services</a> series of articles to learn about options for detecting and handling changes.</p>