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?
A.
You should increase the two Control Flow tasks and one Data Flow task to a container.
Change the TransactionOption property of the container to Supported.
B.
You should increase the two Control Flow tasks and one Data Flow task to a container.
Change the TransactionOption property of the container to Disabled.
C.
You should increase the two Control Flow tasks and one Data Flow task to a container.
Change the TransactionOption property of the container to Required.
D.
You should increase the two Control Flow tasks and one Data Flow task to a container.
Change the TransactionOption property of the container to RequiredNew.
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