Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0×80004005

Check if the RetainSameConnection Option is set to true or false for your Database Connection. I was attempting to Update data by using a Data Flow Transformation OLE DB Source –> OLE DB Command When the RetainSameConnection was set to