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:



Leave a Reply 5

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


Israel

Israel

Must be basic. The Performance will also give you additional data on how long the task took

Israel

Israel

http://www.mattmasson.com/2011/12/what-events-are-included-in-the-ssis-catalog-log-levels/

Of course now that I look at it, it’s a toss up. There is no logging level that just shows on error and onwarning data. The Basic shows all events and the performance also shows the actual performance data of the different data flow components. I guess if you’re most interested in the unimportant goal of logging the least number of different events it would be performance because while it logs less events, there is more overhead because the data it does log takes longer to accumulate. Again a real world goal would be either logging to tune the ssis or logging to accomodate basic everyday function. Stupid question.