What should you do?

To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology.

The methodology has the following requirements:

– Centralized logging in SQL Server

– Simple deployment

– Availability of log information through reports or T-SQL

– Automatic purge of older log entries

– Configurable log details

You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.

What should you do?
A . Deploy the package by using an msi file.
B . Use the gacutil command.
C . Create an OnError event handler.
D . Create a reusable custom logging component.
E . Use the dtutil /copy command.
F . Use the Project Deployment Wizard.
G . Run the package by using the dtexec /rep /conn command.
H . Add a data tap on the output of a component in the package data flow.
. Run the package by using the dtexec /dumperror /conn command.
. Run the package by using the dtexecui.exe utility and the SQL Log provider.
. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

View Answer

Answer: J