PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the custom component is deployed on a test environment correctly

You are developing a SQL Server Integration Services (SSIS) package.
To process complex scientific data originating from a SQL Azure database, a custom task
component is added to the project.
You need to ensure that the custom component is deployed on a test environment correctly.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

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

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

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

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

E.
Configure the output of a component in the package data flow to use a data tap.

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

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

H.
Run the dtutil command to deploy the package to the SSIS catalog and store the
configuration in SQL Server.

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

J.
Open a command prompt and run the dtutil /copy command.
K.
Create a reusable custom logging component and use it in the SSIS project.

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms403356.aspx


Leave a Reply