sql server - sql 2012 ssis All Executions report not showing anything -
i working on migrating sql 2008 ssis package sql 2012. after upgrading , loading package, scheduled it.
the job fails , error says
'package execution on server failed. execution id: 20, execution status:4. view details execution, right-click on integration services catalog, , open [all executions] report'
when open report instructed, shows me zeroes columns - 0 failed, 0 running, 0 succeeded, 0 others
. clicked on filter , applying date; changing date encompass past year , next month, nothing appears.
this first experience sql 2012 , integration services reports.
am missing find execution details?
what happened me issue date filters. ssms defaulting date filters of executions report end @ current date, 2016-11-28. however, in server's time zone, date 2016-11-29. apparently though these filters appear default based on desktop's time zone, applied using server's time zone. able missing executions appear changing date filter include 'tomorrow'.
Comments
Post a Comment