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. You are deploying a new SQL Server Integration Services (SSIS) package to several servers. The package must meet the following requirements: - INET Common Language Runtime (CLR) integration in SQL Server must not be enabled. - The Connection Managers used in the package must be configurable without editing the package. - The deployment procedure must be automated as much as possible. You need to set up a deployment strategy that meets the requirements. What should you do?

Question

Accepted Answer

B. use the dtutll /copy command.

Answer

A. Use the gacutil 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

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

Answer

I. Add a data tap on the output of a component in the package data flow.

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