Reports

Thanks for your answers, the idea is indeed running the package synchronously and also ending with a query to extract the treatment's status (instead of ending with a systematic success), the query is as follows :

IF 7 <> (SELECT [status] FROM [SSISDB].[catalog].[executions] WHERE execution_id = @executionID)
BEGIN
declare @var_log nvarchar(1000)
select top 1 @var_log = message from [SSISDB].[catalog].[event_messages] where operation_id = @executionID and event_name = 'OnError'
RAISERROR(@var_log, 16, 1)
END

79377194