You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The package contains 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.

Ans:  C

0 comments: