TransactionOption

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi,

The screen shot below is from https://technet.microsoft.com/en-us/library/ms141059.aspx.

Can someone explain what would happen if the transaction option for the Execute SQL tasks is changed to supported? Would they join the transaction started by the sequence container or is it completely blocked by the Foreach container?