You develop a series of SQL Server 2008 Integration Services (SSIS) packages. You need to ensure that the following requirements are met: Which component should you use to configure the package?…

Question

Exhibit

Options

• AA SQL Server 2008 table
• BA parent package variable
• CA registry entry
• DAn environment variable
• EAn XML configuration file

• A
  83% (38)
• B
  2% (1)
• C
  11% (5)
• D
  4% (2)

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

No community discussion yet for this question.