You design a Business Intelligence (BI) solution by using SQL Server 2008. You have created an extract, transform, and load (ETL) solution by using SQL Server 2008 Integration Services (SSIS). The solution contains 10 child packages and a parent package that executes the child packages in sequence.
You plan to deploy the solution to 20 locations that are not connected to each other. You need to deploy the solution by configuring the connection managers of all packages with the appropriate settings. You need to achieve this goal by using the minimum amount of administrative effort.
What should you do?
A.
Create an XML configuration file each for the parent package and the child packages.
B.
Create an XML configuration file for the parent package. Configure the child packages by using Parent package variables.
C.
Create a SQL Server configuration each for the parent package and the child packages in a central SQL Server 2008 database.
D.
Create a SQL Server configuration for the parent package in a central SQL Server 2008 database.
Configure the child packages by using Parent package variables.
Explanation:
Tip: "locations that are not connected" = "XML parent / variables child"http://msdn.microsoft.com/en-us/library/ms141682.aspx
Package Configurations
SQL Server Integration Services provides package configurations that you can use to update the values of properties at run time. A configuration is a property/value pair that you add to a completed package. Typically, you create a package set properties on the package objects during package development, and then add the configuration to the package. When the package runs, it gets the new values of the property from the configuration. For example, by using a configuration, you can change the connection string of a connection manager, or update the value of a variable.
Package configurations provide the following benefits:
– Configurations make it easier to move packages from a development environment to a production environment. For example, a configuration can update the path of a source file, or change the name of a database or server.
– Configurations are useful when you deploy packages to many different servers. For example, a variable in the configuration for each deployed package can contain a different disk space value, and if the available disk space does not meet this value, the package does not run.
– Configurations make packages more flexible. For example, a configuration can update the value of a variable that is used in a property expression.
Package Configuration Types
– XML configuration file – An XML file contains the configurations. The XML file can include multiple configurations.
– Environment variable – An environment variable contains the configuration.
– Registry entry – A registry entry contains the configuration.
– Parent package variable- A variable in the package contains the configuration. This configuration type is typically used to update properties in child packages.
– SQL Server table – A table in a SQL Server database contains the configuration. The table can include multiple configurations.