You are developing a SQL Server 2008 SSIS package. The package contains a Sequence
container, which in turn holds a Foreach Loop container and a For Loop container. The Foreach
Loop container updates all the records in a table named Salary of the Employee database using
an Execute SQL task. The For Loop container inserts five records in the Employee_details table of
the Employee database using an Execute SQL task. You need to ensure that if the transaction on
the Sequence task is aborted, the updates made in the Salary table are not rolled back, and the
updates made in the Employee_details table are rolled back.
What should you do? (Choose three.)
A.
Set the TransactionOption property to Required for the Sequence container.
B.
Set the TransactionOption property to NotSupported for the Sequence container.
C.
Set the TransactionOption property to Supported for the For Loop container.
D.
Set the TransactionOption property to Required for the For Loop container.
E.
Set the TransactionOption property to Required for the ForEach Loop container.
F.
Set the TransactionOption property to Supported for the ForEach Loop container.