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 TRUE, I encountered errors.
When the RetainSameConnection was set to FALSE, the package functions as expected.
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0” Hresult: 0x80004005 Description: “Syntax error, permission violation, or other nonspecific error”.