You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named
Orders in a SQL Azure database.
The company’s auditing policies have the following requirements:
• An entry must be written to a dedicated SQL Server log table named OrderLog.
• The entry must be written as soon as the file upload task completes.
You need to meet the company’s policy requirements.
Which event handler should you use?

A.
OnPostExecute

B.
OnWarning

C.
OnExecStatusChanged

D.
OnVariableValueChanged

Explanation:
http://msdn.microsoft.com/en-us/library/ms140223.aspx