Delete command for Oracle table has warning : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Question

I have created an ssis package that processes data on sql server and loads results to an oracle table.
I am using an execute sql task to delete existing records in the oracle table before reloading the table.
The execute sql command has oracle connection that succeeds when tested, The delete statement also works in Oracle sql developer. and is very quick. When the delete statement is run through the execute sql command it throws the following warning, and keeps on running for a long time (until aborted) and does not delete.
"Warning: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

Delete statement is : Delete from GroupSpaceName.TableName
It works from Oracle Sql Developer.

What needs to be done to run the delete statement for oracle table from SSIS. Your help is highly appreciated.

Thanks.

Answer 1

yes, The result set is set to "None"![20291-snapshot1.png][1] [1]: /api/attachments/20291-snapshot1.png?platform=QnA

Answer 2

Hi Deep Kaur,

May I know if you set the ResultSet as None in Execute SQL Task Editor?

Best Regards,
Mona

----------

If the response is helpful, please click "Accept Answer" and upvote it.