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…

Question

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.

Explanation

This question's correct answer was left blank, and the listed answer choices (A–J) are the same set used for Questions 2, 3, and 5 - none of which directly address automated project validation. The intended correct approach for this scenario is to create a SQL Server Agent job scheduled on a regular interval that executes the SSIS Catalog stored procedure catalog.validate_project (or catalog.validate_package for individual packages). This procedure performs the exact validations described - environment references, parameter data types, package references, and referenced assemblies - with minimal setup. Scheduling it via SQL Agent requires almost no ongoing administrative effort. The absence of a correct answer here indicates a likely error in the question's construction.

No community discussion yet for this question.