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.
OnWarning
B.
OnVariableValueChanged
C.
OnExecStatusChanged
D.
OnPostExecute
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms140223.aspx