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 Integration Services 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 utilityand 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:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms140246.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx
The proposed answer is incorrect and to achieve the requirements you would need to use the SSIS Project Deployment model.
Hey there this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding experience so I wanted to get advice from someone with experience. Any help would be enormously appreciated!|
Proposed answer H is correct.
C. Use the Integration Services Deployment Wizard.
because dtexecui.exe utility does not support ‘Automatic purge of older log entries’.