Yes, that is the dream. 🙂

In reality, ETLs, being software, are buggy. To anticipate that, while obviously I work to catch bad data before it ever gets loaded, I...

Dunno if it's worth mentioning, but the downside to the tmp table + update option is the lack of SSIS-level, row-by-row error reporting (which makes sense given you're operating set-based)....