Microsoft
70-458 · Question #27
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…
The correct answer is C. OnPostExecute. See the full explanation below for the reasoning.
Question
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?
Options
- AOnProgress
- BOnlnformation
- COnPostExecute
- DOnComplete
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C81% (21)
- D12% (3)
Community Discussion
No community discussion yet for this question.