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…

Question

Options

• AYou should create an XML configuration file.
• BYou should create a batch file that uses the dtutil utility program to set the package configuration properties
• CYou should Use the SSIS Package Configuration Wizard to create a SQL Server Configuration type.
• DYou should create a .REG file that contains entries for each of the configuration properties.

• A
  7% (3)
• B
  18% (8)
• C
  70% (31)
• D
  5% (2)

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

No community discussion yet for this question.