SSIS 2016 conditional split with multiple columns in conditions
I was close, but no cigar.  If I moved the "upsert the production table" task outside of the ForEach container (but population the staging table with the merge join inside the ForEach container), everything works as expected.