You need to set up a deployment strategy that meets the requirements

You are deploying a new SQL Server Integration Services (SSIS) package to several
servers.
The package must meet the following requirements:
.NET 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?

You are deploying a new SQL Server Integration Services (SSIS) package to several
servers.
The package must meet the following requirements:
.NET 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?

A.
Use the gacutil command.

B.
Use the dtutil /copy command.

C.
Use the Project 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 utility and 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.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Ale

Ale

I think c is not the answer just because CLR must not be enabled

Aakaash

Aakaash

B looks correct because “The deployment procedure must be automated as much as possible”