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 canbe easily configured with the least administrativeand
development effort. Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer areaand arrange them in the correct order.)
Answer:
Explanation:
According to these references, this answer looks correct.
Reference:
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 the project to the SSIS catalog.
4. Configure the project to use an Environment that sets the FilePath parameter.
You have to set the value in the task or component using this file path in packages a and b to use this project parameter instead. That step is missing in this series of steps and add a package parameter … to a and b is tempting but wrong.