I didn't know the error code: 0x80004005 has so confused like above..

In my case, the error caused by duplicated key like this

Error: 0xC0202009 at Data Flow Task, ACR_ARP_DATA Client_ACR_AFW [65]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Duplicate key was ignored.".

Once I have cleared out the duplicated PK conflict, it has resolved.