PrepAway - Latest Free Exam Questions & Answers

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a logging strategy for a SQL Server 2008 Integration Services (SSIS) solution. The SSIS solution contains 15 packages. You want to log detailed information about each package. You need to ensure that custom events specific to each control flow task in each package are logged.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Configure logging for each control flow task in each package for the required events.

B.
Enable the Log Events window in Business Intelligence Development Studio (BIDS) that has the SSIS solution loaded.

C.
Enable event handling for each control flow task in each package for the required events. Create custom code to perform the logging by using a Script component.

D.
Create a custom assembly that writes to the log, and use the assembly in a Script task. Ensure that the Script task is connected to the appropriate control flow task by using a Failure precedence constraint.

Explanation:
Tip: "log detailed information" = "Configure logging"


Leave a Reply