After the data is bulk-inserted into a staging table, I need to do two actions:
Is the JOINS tool the best option, or is there a faster or more effective way to do these tasks?
I think I'd take the following action:
MERGEcommand, which is well designed for only this task: update some current rows, insert some new rows, to do the INSERT/UPDATE into the real data table (and possibly delete some old "orphaned" rows). Almost any insert, update, and delete case may be handled by a single command in a single call.
Check out some excellent articles on using the