You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loopcontainer.
Imports the contents of the files to a table by using a Data Flowtask.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package except the Execute SQL task execute
within a single transaction.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
A.
In the Foreach Loop container, configure the TransactionOption property to NotSupported
B.
In the Data Flow task, configure the TransactionOption property to Required
C.
In the package, configure the TransactionOption property to Required
D.
In the package, configure the TransactionOption property to NotSupported
E.
In the Execute SQL task, configure the TransactionOption property to NotSupported
F.
In the Execute SQL task, configure the TransactionOption property to Supported.