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 … Continue reading "Monitoring SSIS package Job Status"