Posted by: Pdfprep
Post Date: November 24, 2020
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 SSISD
C . [catalog].[executions] view
D . the SSISD
E . [catalog].[event_messages] view
F . the SQL Agent Job History
G . the SQL Agent Error Log
Answer: B
Leave a Reply