You work as a database administrator at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.
You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be
configured to import data into a SQL Azure hosted data warehouse.
You have decided to make use of the Environment Variable package configuration as part of your solution.
Which of the following is TRUE with regards to the Environment Variable package configuration?
A.
It stores the property path inside the package and the value outside the package.
B.
It stores both the property path and the value outside the package.
C.
It is used to fetch a value from a variable in a calling package.
D.
It is the most commonly used configuration type.
Explanation:
A.
It stores the property path inside the package and the value outside the package.