You develop a series of SQL Server 2008 Integration Services (SSIS) packages.
You need to ensure that the following requirements are met:
The packages contain configurations.
The configuration information is centrally stored for all packages.
There are no dependencies among the packages.
Which component should you use to configure the package? (Each correct answer presents
a complete solution. Choose two.)
A.
A SQL Server 2008 table
B.
A parent package variable
C.
A registry entry
D.
An environment variable
E.
An XML configuration file
Explanation:
Integration Services supports several different methods of storing package configurations,
such as XML files, tables in a SQL Server database, and environment and package
variables.
Each configuration is a property/value pair. The XML configuration file and SQL Server
configuration types can include multiple configurations.
The following table describes the package configuration types.
If you select the XML configuration file configuration type, you can create a new
configuration file, reuse an existing file and add new configurations, or reuse an existing file
but overwrite existing file content. If you select the SQL Server configuration type, you
specify the connection to the SQL Server database in which you want to store the
configurations. You can save the configurations to an existing table or create a new table in
the specified database. Note: SSIS (SQL Server Integration Services) is an upgrade of DTS
(Data Transformation Services), which is a feature of the previous version of SQL Server.
Integration Services provides a platform to build data integration and workflow applications.
The primary use for SSIS is data warehousing as the product features a fast and flexible tool
for data extraction, transformation, and loading (ETL). ). The tool may also be used to
automate maintenance of SQL Server databases, update multidimensional cube data, and
perform other functions.
