I'm trying the RetainSameConnection property with a very simple scenario
including two ExecuteSqlTasks: the first has Begin Transaction statement and
the second has a Rollback Transaction statement. Everything works fine if the
Connection Manager is an OleDb Connection, but when using an ADO.NET
connection the "The ROLLBACK TRANSACTION request has no corresponding BEGIN
TRANSACTION", which means that the Connection Manager is not retaining the
same connection.

Any help will be appreciated