You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as a developer of a SQL Server 2008
Integration Services (SSIS) package for the company. The package not only uses a Data
Flow task to import the contents of the files to a table, but also uses a ForEach Loop
container to process multiple files. Besides, it uses an Execute SQL task to log the results of
the status into a table. Now you are assigned a task to make sure that within a single
transaction, both of a Data Flow task and a ForEach Loop container task are executed
successfully, but the Execute SQL task fails to execute. What should you do to achieve this
goal? (Each correct answer presents part of the solution. Choose two.)
A.
You should have the TransactionOption property configured to Required in the package
B.
You should have the TransactionOption property configured to NotSupported in the
Execute SQL task
C.
You should have the TransactionOption property configured to Required in the Data Flow
task.
D.
You should have the TransactionOption property configured to Supported in the Execute
SQL task
E.
You should have the TransactionOption property configured to NotSupported in the
package