You administer a SQL Server Integration Services (SSIS) solution in the SSIS catalog. A SQL Server Agent
job is used to execute a package daily with the basic logging level.
Recently, the package execution failed because of a primary key violation when the package inserted
data into the destination table.
You need to identify all previous times that the package execution failed because of a primary key
violation.
What should you do?
A.
Use an event handler for OnError for the package.
B.
Use an event handler for OnError for each data flow task.
C.
Use an event handler for OnTaskFailed for the package.
D.
View the job history for the SQL Server Agent job.
E.
View the All Messages subsection of the All Executions report for the package.
F.
Store the System::SourceID variable in the custom log table.
G.
Store the System::ServerExecutionID variable in the custom log table.
H.
Store the System::ExecutionInstanceGUID variable in the custom log table.
I.
Enable the SSIS log provider for SQL Server for OnError in the package control flow.
J.
Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.
K.
Deploy the project by using dtutil.exe with the /COPY DTS option.
L.
Deploy the project by using dtutil.exe with the /COPY SQL option.
M.
Deploy the .ispac file by using the Integration Services Deployment Wizard.
N.
Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.
O.
Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.
P.
Create a SQL Server Agent job to execute the
SSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures.
Q.
Create a table to store error information. Create an error output on each data flow destination that
writes OnError event text to the table.
R.
Create a table to store error information. Create an error output on each data flow destination that
writes OnTaskFailed event text to the table.
Hell lot of options!