A Data Flow task in a SQL Server Integration Services (SSIS) package produces run- time errors. You need to
edit the package to log specific error messages. Which three actions should you perform in sequence? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order.)
Answer:
Explanation:
1. Create an OnError event handler for the Data Flow task.
2. Add a Script task
3. In the ReadOnlyVariables list, select system::ErrorDescription and add conditional logic to invoke the FireError method.
0
0