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?
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