Biml and SSIS Frameworks - SQL Server Integration Services Design Patterns - page 536

Now open Parent.dtsx and execute it in the SSDT debugger. Once prompted
by the ErrorTest.dtsx message box, click the No button to cause the Er-
rorTest.dtsx to fail. This should cause the Parent.dtsx package OnError
event handler to fire, as shown in Figure A-13 .
Figure A-13 . I have mixed emotions about successful OnError event handlers
A couple successful and failed executions later, the log.SSISAppInstance
table contains the rows shown in Figure A-14
Figure A-14 . Successes and failures of SSISApp1
That's a wrap on application instance logging! Next, let's build out child package
instance logging.
Building Package Instance Logging
Package instance logging works like application instance logging, only on a different
scale. An application instance consists of an application ID and an execution start time.