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

APEX 5 - interactive report scale resize image

APEX 5 - interactive report re-size image

1. Add image column to interactive report

2. Add blob attributes (image column at your report should be primary key for table with blob content)

3. Add Static ID for your image column (f.e. IDP)

4. Add HTML Header in Page Properties

f.e.

<style type="text/css">

td[headers="IDP"] > img

{ 

width: 150px;

}

</style>