PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

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

The package uses at least one sequence container in one transaction. Each transaction controls a Data Flow task and a Control Flow task. Each Data Flow task has a Success constraint.

The Control Flow task follows the Success constraint. The package must include the following requirements:

Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must succeed or fail as an atomic unit.

A restart point must restart each Data Flow task and the Control Flow task that follows it as an atomic unit.

You need to make changes in the control flow designer to meet the outlined requirements.

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

PrepAway - Latest Free Exam Questions & Answers

A.
Add all the Data Flow tasks and the Control Flow tasks to one sequence container.

B.
Add a sequence container for each Control Flow task and the Data Flow task that precedes it.

C.
Change the FailPackageonFailure property to true for each new sequence container that is added to the package.

D.
Change the FailPackageonFailure property to false for each new sequence container that is added to the package.


Leave a Reply