The implementation of Transaction with out msdtc i

问题:

The transaction has implemented as shows below.When executed it says there is no begin transaction and the whole package exe has been roll backed.

How to get this work with out changing the structure

After the execution

回答1:

For this transaction setup to work with Microsoft DBMS - you have to specify RetainSameConnection=true in Connection Manager properties.
More details on this approach with screenshots.