Which event handler should you use?

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

View Answer

Answer: A