Your organization has five departments.
You are developing a SQL Server 2008 Integration Services (SSIS) project to calculate
salary increases and bonuses under each particular manager.
You need to develop a master package that meets the following requirements:
It must give each department a different ID.
These department IDs must pass on to each individual dependency package inside the
master package.
Each dependency package should have individual security settings to accept department ID
as a variable from its master package.
Which configuration method should you choose from the SSIS configuration options?
A.
SQL Server
B.
Parent package variable
C.
XML configuration file
D.
Environment variable