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 SQLtasks
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.
http://msdn.microsoft.com/zh-tw/library/system.enterpriseservices.transactionoption(v=vs.110).aspx
guys shouldnt it be B??
‘… and all four tasks use the Supported option, the database updates performed by the Execute SQL tasks are rolled back if any task fails’
https://docs.microsoft.com/en-us/sql/integration-services/integration-services-transactions