SQL Server source CDC tables don't contain any markers related to the end of the tx.
Currently we are using the approach of ending the tx when a new one is detected.

This rule can be relaxed on consideration that all events from single tx are visible at the same time - e.g. even the content of CDC table is atomic. If we can prove this is the case then it is quite easy to act on this fact.