Category Archives: SSIS (SQL Server Integration Service)

Dynamic Column Mapping in SSIS : Part 2 (using dts variable)

Previously I have discussed the dynamic column mapping using script component. Now, I am going to mention one more way of dynamic column mapping in SSIS. Let’s say, our source table is Table_1: ID    JAN    FEB    MAR 1    100    200    300 2    400    500    600 3    700    800    900 We want to … Continue reading

Posted in SSIS (SQL Server Integration Service) | Tagged , , , , | 24 Comments

Dynamic Column Mapping in SSIS : Part 1

SSIS Data Flow Task is strictly meta data bound. Input table’s columns are mapped at design time. Let’s say u have a table (Table_1) where column names (JAN,FEB,MAR) are dynamically changed and u don’t have any control over it. SELECT … Continue reading

Posted in SSIS (SQL Server Integration Service) | 20 Comments

Logical OR Condition in EvalExpression of a For Loop Container

If you double click on the For Loop Container of SSIS, a new window will open where you can set up the condition based on which the loop will continue. There is a field called EvalExpression where you can set … Continue reading

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

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