Posted by: Pdfprep
Post Date: October 20, 2020
You need to create the Package Activity report.
What should you do?
A . Create a log table and use SSIS event handlers to write to the log table. Then create an SSRS report that uses the log table.
B . Use the SSIS log provider for SQL Server. Then create an SSRS report that uses the sysssislog table.
C . Create a log table and build a custom log provider to write to the log table. Then create an SSRS report that uses the log table.
D . Create an SSRS report that uses thecatalog.executions and catalog.execution_data_statistics views.
Answer: D
Leave a Reply