Microsoft Exam Questions

Which event handler should you use?

You create a package by using 47 Execute SQL Control Flow tasks. The Execute SQL task returns an error during a calculation of a percentage change over time. You need to add an event handler to the package that processes all of the messages that are returned from each task. Which event handler should you use?

A.
OnError

B.
OnWarning

C.
OnTaskFailed

D.
OnQueryCancel

E.
OnExecStatusChanged