You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You
are designing a SQL Server 2008 Integration Services (SSIS) package. The package uses at least
one sequence container in one transaction. A Data Flow task and a Control Flow task are
controlled by each transaction. Each Data Flow task has a success constraint that is followed by
the Control Flow task. The following requirements should be included in the package:
Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must fail or succeed 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 requirements. What should
you do?
Each correct answer represents a part of the solution. Choose all that apply.
A.
Change the FailPackageonFailure property to true for each new sequence container that is
added to the package.
B.
Add a sequence container for each Control Flow task and the Data Flow task that precedes it.
C.
Change the FailPackageonFailure property to false for each new sequence container that is
added to the package.
D.
Change the FailPackageonFailure property to true for the package.