70-448 · Question #25
You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The SSIS package must contain six Data Flow tasks and three Control Flow tasks. You should alter the package…
The correct answer is C. You should increase the two Control Flow tasks and one Data Flow task to a container. If a series of tasks must be completed as a single unit in which either all the tasks are successful and committed or an error occurs and none of the tasks are committed, place the tasks within a Sequence Container and then set the TransactionOption property of the container to…
Question
You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The SSIS package must contain six Data Flow tasks and three Control Flow tasks. You should alter the package .Which is the correct answer?
Options
- AYou should increase the two Control Flow tasks and one Data Flow task to a container.
- BYou should increase the two Control Flow tasks and one Data Flow task to a container.
- CYou should increase the two Control Flow tasks and one Data Flow task to a container.
- DYou should increase the two Control Flow tasks and one Data Flow task to a container.
How the community answered
(41 responses)- A12% (5)
- B7% (3)
- C78% (32)
- D2% (1)
Explanation
If a series of tasks must be completed as a single unit in which either all the tasks are successful and committed or an error occurs and none of the tasks are committed, place the tasks within a Sequence Container and then set the TransactionOption property of the container to Required
Topics
Community Discussion
No community discussion yet for this question.