DRAG DROP
You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS).
Two packages, Package A and Package B, will be designed. Package A will execute Package B.
Both packages must reference a file path corresponding to an input folder where files will be located for
further processing.
You need to design a solution so that the file path can be easily configured with the least administrative
and development effort.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the
list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation
Explanation:
Box 1:
Box 2:
Box 3:
Box 4:
http://msdn.microsoft.com/en-us/library/hh479588.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx
1. Create an SSIS project containing Package A and Package B.
2. Add a Project Parameter named FilePath
3. Deploy project to SSIS catalog
4. Configure the Project to use an Evironment that sets the FilePath parameter
0
0
Since the question doesn’t mention anything about an environment, I don’t think that is the correct answer. It does mention Package A calling Package B, which suggests using a Parent Package variable. So
1. Create an SSIS project containing Package A and Package B
2. Add a package parameter named FilePath To Package A and Package B
3. Add a configuration file in Package A to set the Filepath value
4. Add a parent package variable configuration in Package B to set the filepath variable
0
0