What should you do?

Posted by: Pdfprep Category: 70-463 Tags: , ,

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?
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.
. Use an msi file to deploy the package on the server.
. Open a command prompt and run the dtutil /copy command.
. Create a reusable custom logging component and use it in the SSIS project.

Answer: B

Explanation:

Reference:

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

Leave a Reply

Your email address will not be published.