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?
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