PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply