You work as a database developer at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You have been asked to revise a SQL Server Integration Services (SSIS) package. The package
only includes Execute SQL tasks.
To make sure that, in the event of an Execute SQL task failing, changes made by all of the
Execute SQL tasks is rolled back. To do this, you want to alter the TransactionOption property of
the package.
Which of the following is the value that must be set for the TransactionOption property of the
package?
A.
NotSupported.
B.
Supported.
C.
NotRequired.
D.
Required.
Explanation: