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.
Answer: J