You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
Now in Business Intelligence Development Studio, you are developing a SQL Server 2008 Integration Services (SSIS) project.
You configure the project properties as shown in the following image. You need to create a deployment manifest for all packages in the project. What should you do? (Exhibit)
A.
You should view the code of each Data Transformation Services (DTS) package. Then you should copy the first <DTS:Property> xml node to a file with a .SSISDeploymentManifest file extension.
B.
You should build the Integration Services project
C.
You should modify the AllowConfigurationChanges property of the project
D.
You should copy each package. Then you should rename each copy with a .SSISDeploymentManifest file extension
Explanation:
MCTS Self-Paced Training Kit (Exam 70-448) p 120
The next step is to run a build process on the SSIS project to generate the deployment set.
To do this, right-click the SSIS project in Solution Explorer and then click Build.