How can you find this information?

A SQL Server Integration Services (SSIS) package was deployed two weeks ago with the Project
Deployment Model.
Sometimes the package is started as part of a multistep SQL job. At other times, the package is started
manually by a database administrator 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 executes.
How can you find this information?

A SQL Server Integration Services (SSIS) package was deployed two weeks ago with the Project
Deployment Model.
Sometimes the package is started as part of a multistep SQL job. At other times, the package is started
manually by a database administrator 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 executes.
How can you find this information?

A.
In the SSISDB.[catalog], query the .[executions] view.

B.
In the SSISDB.[catalog] , query the [event_messages] view.

C.
In SQL Server Management Studio, view the SQL Agent Job History.

D.
In SQL Server Management Studio, view the SQL Agent Error Log.

E.
In SQL Server Management Studio, view the SQL Server Log.



Leave a Reply 0

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