Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. 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?

Question

Accepted Answer

H. Run the package by using the dtexecui.exe utility and the SQL Log provider.

Answer

A. Use the gacutil command.

Answer

B. Use the dtutil /copy command.

Answer

C. Use the Project Deployment Wizard.

Answer

D. Create an OnError event handler.

Answer

E. Create a reusable custom logging component.

Answer

F. Run the package by using the dtexec /rep /conn command.

Answer

G. Run the package by using the dtexec /dumperror /conn command.

Answer

J. Deploy the package by using an msi file.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is…

Question

Options

How the community answered

Community Discussion