Friday, March 9, 2012

Negative #Abort from SSIS Event Log report

I am using the sample SSIS Event Log reports provided by Microsoft: http://www.microsoft.com/downloads/details.aspx?familyid=526e1fce-7ad5-4a54-b62c-13ffcd114a73&displaylang=en

The Event Log Summary report is showing a negative value for #Abort. Why is the aborted count negative?

I found the answer. Abort is calculated using this formula:

Executions - Succeed - Fail = Abort

I started a package just before midnight on day 1 that completed just after midnight on day 2. The date from and date to parameters I used only included day 2. It looked like a package succeeded that had not been started.

No comments:

Post a Comment