You are creating a SQL Server 2008 Integration Services (SSIS) package which should be
intercalated on 20 servers for Company.com.
You can’t visit the file system of any server.
You should change the package setting attributes when package is running.
Which is the correct answer below?

A.
You should create an XML configuration file. Select the XML configuration type in the
SSIS Package Configurations Organizer.

B.
You should create a batch file that uses the dtutil utility program to set the package
configuration properties while the package deploys into production.

C.
You should Use the SSIS Package Configuration Wizard to create a SQL Server
Configuration type. Select a centralized Microsoft SQL Server to store the package
configuration

D.
You should create a .REG file that contains entries for each of the configuration
properties.
Select a single Registry Configuration type in the SSIS Package Configurations

Explanation:
Type Description
XML Configuration File Stores configuration settings in an XML file in the file system.Select
XML Configuration File if you are comfortable working with configuration files and your
project requirements let you store configuration information in a file system file. You can
store multiple configurations in a single XML file. Environment Variable Saves the
configuration information inside the system’s global variables collection, which is called an
environment variable. When you add an Environment Variable configuration, you can
choose only one property for each Environment Variable configuration. Registry Entry Lets
you save package properties and settings inside your computer’s registry. You can select
multiple configuration settings at a time and store them in the registry. Parent Package
Variable Provides a way to inherit the value of a variable from a parent package. When a
package is executed from another SSIS package by using the Execute Package Task, the
values of its variables are available to the child package through the Parent Package
Variable configuration. With this configuration type, you can choose only one package
property setting at a time. SQL Server Uses a SQL Server table to store the package setting
information.This configuration setting lets you store multiple configurationsin a single table.
Creating a SQL Server Configuration If you decide to store your package configurations in a
SQL Server table, select SQL Server from the Configuration Type drop-down list in the
Package Configuration Wizard. Using Microsoft SQL Server as the storage mechanism for
your configurations requires a different group of settings from what the other configuration
types, such as the XML Configuration File, use. Figure 3-5 shows the SQL Server
configuration options available for setting up configurations EXAM TIP Packages can share
SQL Server configurations even if they are running on different servers because the SQL
Server configuration does not have to be stored on the local server, unlike the other confi
guration types