70-463 · Question #68
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:
The correct answer is C. OnPostExecute. The OnPostExecute event handler fires immediately after a task finishes executing, making it the correct choice to write an audit log entry as soon as the file upload task completes.
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
(41 responses)- A2% (1)
- B2% (1)
- C88% (36)
- D7% (3)
Why each option
The OnPostExecute event handler fires immediately after a task finishes executing, making it the correct choice to write an audit log entry as soon as the file upload task completes.
OnProgress fires during task execution to report incremental progress and does not indicate that the task has finished.
OnInformation fires only when a task explicitly raises an informational message and is not guaranteed to fire on task completion.
OnPostExecute is raised immediately after a task's or container's Execute method returns, regardless of success or failure. By attaching the log-write logic to this event handler on the file upload task, the OrderLog entry is guaranteed to be written as soon as the task finishes, directly satisfying the auditing policy requirement.
OnComplete is not a standard SSIS event handler; the correct event for capturing the moment after task execution ends is OnPostExecute.
Concept tested: SSIS OnPostExecute event handler for post-task audit logging
Source: https://learn.microsoft.com/en-us/sql/integration-services/integration-services-ssis-event-handlers
Topics
Community Discussion
No community discussion yet for this question.