Suppose we have scheduled our packages through SQL Server Agent Job and we receive the notification that one of our packages has failed.
To get its details, within SSISDB, we can check the Standard Reports like Integration Services Dashboard report, All Executions etc. to get the details.
This will provide the information about the operation that have run or are currently executing.
We can click on Failed record link to filter the report.
Or we can Filter it through Filter Settings…
