Microsoft
70-458 · Question #147
70-458 Question #147: Real Exam Question with Answer & Explanation
See the full explanation below for the reasoning.
Question
You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Windows Azure SQL Database database. An automated process must validate all related Environment references, parameter data types, package references, and referenced assemblies. The automated process must run on a regular schedule. You need to establish the automated validation process by using the least amount of administrative effort. 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.
Community Discussion
No community discussion yet for this question.