Q 1. You've designed a "parent" package that will execute several "child" packages. You would like to pass the database connection string from the parent to each of the child packages as they run. How will you implement the desired functionality?
Q 2. When a Lookup transform fails to find a matching row, an error condition is raised. What are the valid actions you can configure a Lookup transform to perform when this error is raised?
Q 3. You are a part of SSIS developer team and have been asked by your lead to process SSAS cube once the pull is completed. Using which of the following SSAS transformations you can process SSAS cubes?