1.An SSIS package container that is used to perform iterative processes.
For Loop Containers
Foreach Loop Containers
2.Using a sequence container, you can ___________________________________________________
Manage properties for a single task
Manage properties for multiple tasks
None of the above.
3.__________ variables store information about the running package and its objects
4.The ability to run multiple control flows in parallel is a result of the SSIS's ability to use __________ packages
1.When developing an application you must use ______________ techniques to find the cause of the problems and formulate a solution.
2.Which of the following is a technique that can be used for debugging during development?
Observe row counts and task outcomes.
Step through package execution using breakpoints
View variable values
All of the above
3._____________________ can be used to pause execution at the stage where errors occur.
None of the above
4.The SSIS log ____________________ defines the specific details that can be logged for each event.
1.No matter how much debugging you do, exceptions that cause errors can occur in any ETL process.