Where can you find this information?

A SQL Server Integration Services (SSIS) package ona computer is failing periodically in production. The
package was created less than one year ago and was deployed to the SSIS catalog. Sometimes the packageis
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 thepast. Where can you find this information?

A SQL Server Integration Services (SSIS) package ona computer is failing periodically in production. The
package was created less than one year ago and was deployed to the SSIS catalog. Sometimes the packageis
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 thepast. 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

Explanation:
Looks Correct



Leave a Reply 0

Your email address will not be published. Required fields are marked *