PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

You create a Microsoft SQL Server 2005 Integration Services (SSIS) project by using Business Intelligence Development Studio (BIDS). The project contains 75 SSIS packages stored in the file system that perform various maintenance tasks. The SSIS packages must be available to the Quality Assurance (QA) team to test the packages on the test server. You need to create a package deployment utility that allows the QA team to deploy each of these packages on the test server. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Add a SQL Server Import/Export Wizard item to the SSIS project.

B.
Ensure that the InteractiveMode SSIS project property is set to false.

C.
Ensure that the CreateDeploymentUtility SSIS project property is set to true.

D.
Ensure that the SSIS Project Active Build configuration is set to Development.

E.
Build the entire SSIS project and copy the contents of the \bin\Deployment folder from your server to the QA server.


Leave a Reply