PdfPrep.com

What should you do?

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?
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.
. Configure the SSIS solution to use the Project Deployment Model.
. Configure the output of a component in the package data flow to use a data tap.
. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

Answer: I

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

Exit mobile version