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”.

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

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

How to run MDX/Create local cubes from SSIS

Just drag an Execute SQL Task and double click to open SQL Task Editor. Under the SQL Statement section, you will find the slot for Connection. Click on New connection and you will see the Configure OleDb connection Manager window. Click on the New button. Now , you will find the window called Connection Manager.¬†Click¬†the … More How to run MDX/Create local cubes from SSIS