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: 
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
Why are the package A and B are created in different projects?
Create an SSIS project containing Package A and Package B.
Add a project parameter named FilePath.
Deploy the project to the SSIS catalog.
Configure the project to use an Environment that sets the FilePath parameter.
I Agree with you
agree
Agree with Koala, don’t see any reason to create them in different projects.
Couldn’t agree more with Koala.
agree with Koala……….. right answer.
Yes, I agree with Koala too. If you create package B in a separate project, it won’t be able to see project parameter from project with Package A.
Create an SSIS project containing Package A and Package B.
Add a project parameter named FilePath.
Deploy the project to the SSIS catalog.
Configure the project to use an Environment that sets the FilePath parameter.
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.