PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the project is deployed to the SSIS catalog on the production server

You are developing a SQL Server Integration Services (SSIS) project that copies a large
amount of rows from a SQL Azure database. The project uses the Package Deployment
Model. This project is deployed to SQL Server on a test server.
You need to ensure that the project is deployed to the SSIS catalog on the production
server.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Open a command prompt and run the dtexec /dumperror /conn command.

B.
Create a reusable custom logging component and use it in the SSIS project.

C.
Open a command prompt and run the gacutil command.

D.
Add an OnError event handler to the SSIS project.

E.
Open a command prompt and execute the package by using the SQL Log provider and
running the dtexecui.exe utility.

F.
Open a command prompt and run the dtexec /rep /conn command.

G.
Open a command prompt and run the dtutil /copy command.

H.
Use an msi file to deploy the package on the server.

I.
Configure the SSIS solution to use the Project Deployment Model.

J.
Configure the output of a component in the package data flow to use a data tap.
K.
Run the dtutil command to deploy the package to the SSIS catalog and store the
configuration in SQL Server.

Explanation:
References:
http://msdn.microsoft.com/en-us/library/hh231102.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx

One Comment on “You need to ensure that the project is deployed to the SSIS catalog on the production server


Leave a Reply