SSIS oracle DB connectivity Issue

0

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

Error at Task_Name [OLE DB Destination [81]]: Failed to open a fastload rowset for Table_Name.Check that the object exists in the database.

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!!

oracle
ssis
sql-server-2012
etl
ssis-2012
asked on Stack Overflow Jan 19, 2018 by Sukanya • edited Jan 19, 2018 by Sukanya

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0