DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005
I was hit with this VERY generic error writing data to DB2/i in SSIS using MS OLEDB for DB2.
After much searching and troubleshooting, I discovered that this error is thrown whenever you try to insert a NULL into a non nullable column.
Hope this helps someone else save a few hours of work.