You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loop container.
Imports the contents of the files to a table by using a Data Flow task.
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 execute within a single transaction.
What should you do?
A.
In the ForEach Loop container, configure the TransactionOption property to
NotSupported.
B.
In the package, configure the TransactionOption property to Required.
C.
In the Data Flow task, configure the TransactionOption property to Required.
D.
In the package, configure the TransactionOption property to NotSupported.