SSIS - Call oracle procedure from Microsoft SQL Server integration services

SSIS - Call oracle procedure from Microsoft SQL Server integration services

1. Create sample procedure f.e.

create or replace PROCEDURE  schema1.delete_proc is

begin

delete from table;

end;

2. Add Execute SQL Task component at your ssis project with following parameters

3. Syntax

{CALL <schema>.<procedure>}

{CALL <schema>.<procedure>(parameter1='value1')}