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.)
Explanation:
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
wrong answer
The correct answer should be:
x Create an SSIS project containing Package A and Package B
x Add a package parameter named FilePath
x Deploy the project to the SSIS catalog.
x Configure the project to use an Environment that sets the FilePath parameter
I believe you are wrong on the your second answer.
It should be
x Create an SSIS project containing Package A and Package B
x Add a PROJECT parameter named FilePath
x Deploy the project to the SSIS catalog.
x Configure the project to use an Environment that sets the FilePath parameter
See the link here: https://msdn.microsoft.com/en-us/library/hh213214.aspx
@ bayou is right !! wrong answer
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.