Which setting should you use?

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by
using SQL Server Management Studio.
You need to execute the package and minimize the number of event types that are logged.
Which setting should you use? (To answer, change the appropriate setting in the answer
area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by
using SQL Server Management Studio.
You need to execute the package and minimize the number of event types that are logged.
Which setting should you use? (To answer, change the appropriate setting in the answer
area.)

Answer:

Explanation:



Leave a Reply 5

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

four × three =


Milen

Milen

Verbose ?

Milen

Milen

My fault. I didn’t read carefully – “minimize the number of event types “

Henry Figgins

Henry Figgins

Basic: Warnings and errors
Performance: Includes how long the steps took to execute and is thus unnecessary.
I think its basic

Also, if we just put the all the answers supplied by this site on the test, we’d all fail

Henry Figgins

Henry Figgins

I’ve seen this elsewhere now. It’s performance because while performance also gives you speed of execution and is actually a greater hindrance toward the execution of the package, basic logs all events except custom and diagnostic

jaspreet

jaspreet

Performance Only performance statistics, and OnError and OnWarning events, are logged.

The Execution Performance report displays Active Time and Total Time for package data flow components. This information is available when the logging level of the last package execution was set to Performance or Verbose. For more information, see Reports for the Integration Services Server.