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

Explanation:

Reference: http://msdn.microsoft.com/e n-us/library/ms140223.aspx