PdfPrep.com

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.

Answer: J

Explanation:

References:

http://msdn.microsoft.com/en-us/library/ms140246.aspx

http://msdn.microsoft.com/en-us/library/ms180378(v= sql.110).aspx

Exit mobile version