You need to meet the company’s policy requirements.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?

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:
According to this reference, this answer looks correct.
Reference: http://msdn.microsoft.com/en-us/library/ms140223.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Howie

Howie

D.
OnPostExecute