Microsoft
70-458 · Question #149
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. The package consists of several data flow tasks. The package experiences intermittent errors…
The correct answer is I. Enable the SSIS log provider for SQL Server for OnError in the package control flow. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. The package consists of several data flow tasks. The package experiences intermittent errors in the data flow tasks. If any data flow task fails, all package error information must be captured and written to a SQL Server table by using an OLE DB connection manager. You need to ensure that the package error information is captured and written to the table. What should you do?
Options
- AUse an event handler for OnError for the package.
- BUse an event handler for OnError for each data flow task.
- CUse an event handler for OnTaskFailed for the package.
- DView the job history for the SQL Server Agent job.
- EView the All Messages subsection of the All Executions report for the package.
- FStore the System::SourceID variable in the custom log table.
- GStore the System::ServerExecutionID variable in the custom log table.
- HStore the System::ExecutionInstanceGUID variable in the custom log table.
- IEnable the SSIS log provider for SQL Server for OnError in the package control flow.
- JEnable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.
How the community answered
(55 responses)- A11% (6)
- C2% (1)
- E2% (1)
- H5% (3)
- I80% (44)
Community Discussion
No community discussion yet for this question.