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