http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660"It quite trivial to allow update / insert based on a given set of key fields, and it is certainly something that I would expect to see in an ETL product." It's also pretty trivial to add this logic to an SSIS package using a lookup. Upserts without db support can be fairly slow. " Given the common need for this. Even something that was DB specific would be welcomed." SQL 2008 is adding the MERGE statement, which you can use from SSIS - I have posted about it on my blog. http://ayende.com/2659/ssis-the-backlash#comment2http://ayende.com/2659/ssis-the-backlash#comment2Fri, 27 Jul 2007 18:01:55 GMTOren, I tried to post a reply here but your blog barfed at me. Hence, I have updated my original post here: http://blogs.conchango.com/jamiethomson/archive/2007/07/27/SSIS_3A00_-The-backlash-continues.aspx -Jamie http://ayende.com/2659/ssis-the-backlash#comment1http://ayende.com/2659/ssis-the-backlash#comment1Fri, 27 Jul 2007 17:33:10 GMT