I am getting the below mentioned error in one of the task in SSIS package.
Exception from HRESULT: 0xC0202040 Error at Populate data combined data [OLE DB Destination [81]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
I have Microsoft visual studio 2010 shell, server management studio 2012 installed in my machine and also I have installed ODTwithODAC121012 and attunitySSISOraAdapters for the DB connectivity.
enter image description here I tested the connection to the oracle DB and it is success.
Please let me know if there is something wrong with the connection setups.
Thanks in Advance!!
User contributions licensed under CC BY-SA 3.0