We use MERGE with the OUTPUT clause a lot for maintaining our data warehouse insurance claims table, and like Doug Bishoop says, we use the OUTPUT as the source of...
I was able to get the error column in at least one previous version of SSIS. It wasn't very difficult, either, though I don't recall exactly how it was done.