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.
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:
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
At first glance, it can’t be I. That is for project deployment. The question clearly states The project uses the Package Deployment Model. The only way to do that is dtutil which can deploy to the server.
https://msdn.microsoft.com/en-us/library/ms162820(SQL.90).aspx
However then it says “You need to ensure that the project is deployed to the SSIS catalog” which can only be accomplished as a project, not a package and can be done with I. So to be really clear, the question should have said, you want to redeploy the package to the ssisdb under the project deployment method.
I