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...