SSIS - Start job with different account (credencials)

SSIS - Start job with different account (credentials)

1. Create new credentials (existing AD/local user)  at SQLServer->Security-Credentials

2. Create proxy SQLAgent->Proxies->SSIS Package execution (if you want to use it for ssis package)

3. At job step choose run as (created proxy)

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

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')}