You need to meet the company’s policy requirements. Which event handler should you use?

You are designing a SQL Server Integration Services (SS1S) 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 . OnProgress
B . Onlnformation
C . OnPostExecute
D . OnComplete

View Answer

Answer: C

Explanation:

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