You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
According to the requirement of the company CIO, you use SQL Server 2008 Integration Services (SSIS) to create a package.
The exhibit below shows the structure of the package. You have to define a variable. The variable contains sensitive information that can only be accessed by the Sequence Container, the Data Flow Task, and the Execute SQL Task.
What action should you perform? (Exhibit)
A.
At the Data Flow Task scope, the variable should be created
B.
At the package scope, the variable should be created
C.
At the Sequence Container scope the variable should be created
D.
At the Execute SQL Task scope, the variable should be created