SSIS - odbc oracle delete query

SSIS - problem with odbc oracle delete query

SQL delete query which is not affecting any records will return the result SQL_NO_DATA. SSIS odbc is not able to handle this kind of result.

1. Create query with dual select at the end
delete from table;
select 1 from dual;

2. Create procedure to delete data

create or replace PROCEDURE  delete_table is
begin
delete from table;
end;

Source: https://stackoverflow.com/questions/55000421/delete-statement-fails-when-called-from-ssis