I am working on migrating a SQL 2008 SSIS package to SQL 2012. After upgrading and loading the package, I scheduled it.
The job fails and the error says
'Package execution on IS Server failed. Execution ID: 20, Execution Status:4. To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report'
When I open the report as instructed, it shows me zeroes for all columns - 0 failed, 0 running, 0 succeeded, 0 others
. I clicked on the filter and it is applying only a date; changing the date to encompass the past year and next month, nothing appears.
This is my first experience with SQL 2012 and the Integration Services reports.
Am I missing something to find the execution details?
What happened to me was an issue with the date filters. SSMS was defaulting the date filters of the All Executions report to end at the current date, 2016-11-28. However, in the server's time zone, the date was 2016-11-29. Apparently even though these filters appear to default based on your desktop's time zone, they are applied using the server's time zone. I was able to get the missing executions to appear by changing the date filter to include 'tomorrow'.