It should be easier to execute tasks within a transaction, so that you do not have to set this up yourself.
Completed
Executing tasks in a transaction
+5It is now possible to mark a stored procedure task or stored procedure subroutine to execute as an atomic transaction for SQL Server and DB2. This will affect the generated code for this stored procedure.
+7I think this should even be the default setting.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.