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?
Correct Answer: A
Explanation/Reference:
Explanation:
The event handler for the OnPostExecute event is raised by an executable immediately after it has finished running.
Incorrect Answers:
B: The event handler for the OnExecStatusChanged event is raised by an executable when its execution status changes.
References: https://docs.microsoft.com/en-us/sql/integration-services/integration-services-ssis-event- handlers?view=sql-server-2017