Microsoft
70-448 · Question #248
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…
The correct answer is B. In the package, configure the TransactionOption property to Required. See the full explanation below for the reasoning.
Question
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 execute within a single transaction. What should you do?
Options
- AIn the ForEach Loop container, configure the TransactionOption property to NotSupported.
- BIn the package, configure the TransactionOption property to Required.
- CIn the Data Flow task, configure the TransactionOption property to Required.
- DIn the package, configure the TransactionOption property to NotSupported.
How the community answered
(31 responses)- A6% (2)
- B74% (23)
- C3% (1)
- D16% (5)
Community Discussion
No community discussion yet for this question.