Microsoft Exam Questions

What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package includes five Data Flow tasks and three Control Flow tasks. You need to modify the package so that two Control Flow tasks and one Data Flow task fail or succeed as a unit. What should you do?

A.
Change the TransactionOption property of each of the two Control Flow tasks and one Data Flow Task to Supported.

B.
Change the TransactionOption property of each of the two Control Flow tasks and one Data Flow task to Required.

C.
Add the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Required.

D.
Add the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Supported.