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.
OnProgress
B.
Onlnformation
C.
OnPostExecute
D.
OnComplete
Explanation:
According to this reference, this answer looks correct.
Reference: http://msdn.microsoft.com/en-us/library/ms140223.aspx
D.
OnComplete
Correct answer is : C- OnPostExecute. There is no such option as OnComplete in SSIS event handler