It looks like an error occurred simply because I see an On Error task firing.

take a look at the Event Handler tab to see what might be lurking under On Error. Maybe that piece is flawed?

I don't make a lot of use of Event Handlers aside from rudimentary logging but maybe if you remove the On Error event handler you will be able to let it break and see what the error really is?

Do check for nulls in your data flow in case it's something like integrity constraint violation as it does appear that No records were written.

Agree, SSIS can be extremely frustrating.