PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.

The package has the following features:

Two Data Flow tasks and two Control Flow tasksA success constraint between each Data Flow task and the subsequent Control Flow task

The package uses one transaction for all the tasks.

You need to configure the package so that the two Data Flow tasks use their own transactions. You also need to ensure that each Control Flow task is enlisted in the same transaction as its preceding Data Flow task.

Which three actions should you perform? (Each correct answer presents part of the solution.
Choose three.)

PrepAway - Latest Free Exam Questions & Answers

A.
Change the TransactionOption property to Supported for the package.

B.
Change the TransactionOption property to Required for the package.

C.
Change the TransactionOption property to Supported for each Data Flow task.

D.
Change the TransactionOption property to Required for each Data Flow task.

E.
Change the TransactionOption property to Supported for each Control Flow task.

F.
Change the TransactionOption property to Required for each Control Flow task.


Leave a Reply