70-463 · Question #91
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 correct answer is B. the SSISDB.[catalog].[executions] view. The SSISDB.[catalog].[executions] view records every execution of a package in the SSIS catalog, including the 'executed_by_name' column that shows the Windows or SQL login that initiated the execution-covering both SQL Agent-scheduled runs and manual executions launched from…
Question
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?
Options
- Athe SQL Server Log
- Bthe SSISDB.[catalog].[executions] view
- Cthe SSISDB.[catalog].[event_messages] view
- Dthe SQL Agent Job History
- Ethe SQL Agent Error Log
How the community answered
(43 responses)- B88% (38)
- C7% (3)
- D2% (1)
- E2% (1)
Explanation
The SSISDB.[catalog].[executions] view records every execution of a package in the SSIS catalog, including the 'executed_by_name' column that shows the Windows or SQL login that initiated the execution-covering both SQL Agent-scheduled runs and manual executions launched from SSMS Object Explorer. The SQL Server Log (A) records engine-level events, not SSIS execution callers. The [catalog].[event_messages] view (C) stores runtime messages and errors for an execution but not the initiating user. SQL Agent Job History (D) only covers Agent-scheduled runs and identifies the Agent proxy or service account, not necessarily the person who set it up. The SQL Agent Error Log (E) contains Agent service errors, not package execution details.
Topics
Community Discussion
No community discussion yet for this question.