You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains 30 Data Flow tasks and 30 Control Flow tasks. The package runs slower than expected. You need to capture the start time, the finish time, and the elapsed time for the validation
and execution of the package. What should you do?
A.
Enable the OnProgress event handler and use the Control Flow tasks to write the information to a log.
B.
Monitor the Progress tab during the execution of the package, and then monitor the Execution Results tab.
C.
Use the Performance Monitor tool to capture the counters from the SQL Server: SSIS Service object. Analyze the output for the required information.
D.
Use the Performance Monitor tool to capture the counters from the SQL Server: SSIS Pipeline object.
Analyze the output for the required information.