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