Dude!  You are my hero!
Thank you so much for posting back your solution. I had the exact same problem:
 490K rows transferred to SQL (out of millions) and yellow...

I had the same issue but with my analysis the NETWORK SERVICE needed the following:

'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config' - Desired Access: Generic Read

Granted READ access for NETWORK SERVICE to that file and SSIS...

I had the same error. When I checked the log file the hotfix created (click Summary at the end of the installation) I found the following error:

----

MSP Error: 29538 ...