Top Posts & Pages
Category Archives: SSIS (SQL Server Integration Service)
SSIS Error: [OLE DB Destination ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: “OraOLEDB” Hresult: 0x80004005 Description: “ORA-01031: insufficient privileges”.
Have you ever faced with this error in the SSIS? The full error message might look like below: [OLE DB Destination ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record … Continue reading
Recently, I have been working in a project where I had to make an SSIS package to connect to an Oracle server and load data to a SQL server. After searching a lot and getting through a lot, I figured … Continue reading