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?

Question

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?

Accepted Answer

B. Parent package variable

Answer

A. SQL Server

Answer

C. XML configuration file

Answer

D. Environment variable

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…

Question

Options

How the community answered

Community Discussion