Category: SSIS (SQL Server Integration Service)

SSIS Error: [OLE DB Destination [25]] 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”.

March 28, 2011

Have you ever faced with this error in the SSIS? The full error message might look like below: [OLE DB Destination [25]] 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”. [OLE DB Destination [25]] Error: … More SSIS Error: [OLE DB Destination [25]] 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”.

Oracle and SQL server connection in SSIS: Best provider

March 25, 2011

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 out the best provider and client for a successful connection. Take note from the following … More Oracle and SQL server connection in SSIS: Best provider