A SQL Server Integration Services (SSIS) package on a computer is failing periodically in
production. The package was created less than one year ago and was deployed to the SSIS
catalog.
Sometimes the package is started on a SQL Agent schedule; sometimes the package is
started manually by an SSIS developer by using the Object Explorer in SQL Server
Management Studio.
You need to identify the authenticated user responsible for starting the package each time it
failed in the past.
Where can you find this information?
A.
the SQL Server Log
B.
the SSISDB.[catalog].[executions] view
C.
the SSISDB.[catalog].[event_messages] view
D.
the SQL Agent Job History
E.
the SQL Agent Error Log
Isn’t D also correct?
Thought that too first, but a lot of people I have spoken to also say it’s B. So I am going with B
One of the condition says that sometimes package is started manually. So in that case no information about running that package will be written to the SQL Agent Job History because package was not started by the SQL Agent. So B is correct.