Really, staging table and a merge statement is all you need (2008+). For 2005 I'd just use a proc to replicate the functionality of the merge statement. SSIS is massive overkill for this kind of function (and many other examples I see on a daily basis).