Which is the correct answer below?

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 systems 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 computers 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