Category Archives: 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”.

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 … Continue reading

Posted in SSIS (SQL Server Integration Service) | 1 Comment

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 … Continue reading

Posted in SQL, Database, SSIS (SQL Server Integration Service) | Leave a comment

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. … Continue reading

Posted in MDX, SSAS (Analysis Service), Cube, SSIS (SQL Server Integration Service) | 3 Comments