You are a professional level SQL Sever 2008 Database Administrator in an international
corporation named Wiikigo. There is a team of database administrators in your company.
SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a
shared project by a team of application developers. A fixed cache file is required by one of
the packages. The company will deploy the packages to the production server on
completion of development. The production server is available only to the database
administrators. Since you are the technical support, you need to confirm that the project can
be deployed successfully to the production server by the application developers. Which
action will you perform to achieve the goal?
A.
To achieve the goal, a deployment utility should be created for the SSIS project.
B.
To achieve the goal, an indirect package configuration should be created for all
packages.
C.
To achieve the goal, a direct package configuration should be created for each package.
D.
To achieve the goal, the Import and Export Wizard should be utilized to save packages.