Microsoft
70-463 · Question #149
70-463 Question #149: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #149. The question stem and answer options stay visible for context.
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.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.