What should you do?

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place.

The methodology has the following requirements:

• The deployment process must be simplified.

• All the logs must be centralized in SQL Server.

• Log data must be available via reports or T-SQL.

• Log archival must be automated.

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 . Open a command prompt and run the gacutil command.
B . Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
C . Add an OnError event handler to the SSIS project.
D . Use an msi file to deploy the package on the server.
E . Configure the output of a component in the package data flow to use a data tap.
F . Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
G . Open a command prompt and run the dtexec /rep /conn command.
H . Open a command prompt and run the dtutil /copy command.
. Open a command prompt and run the dtexec /dumperror /conn command.
. Configure the SSIS solution to use the Project Deployment Model.
. Create a reusable custom logging component and use it in the SSIS project.

View Answer

Answer: B

Explanation:

Reference:

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

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