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.
Use the gacutil command.
B.
Use the dtutil /copy command.
C.
Use the Project Deployment Wizard.
D.
Create an OnError event handler.
E.
Create a reusable custom logging component.
F.
Run the package by using the dtexec /rep /conn command.
G.
Run the package by using the dtexec /dumperror /conn command.
H.
Run the package by using the dtexecui.exe utility and the SQL Log provider.
I.
Add a data tap on the output of a component in the package data flow.
J.
Deploy the package by using an msi file.
K.
Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store
the configuration.
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms140246.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx