When this error occurred to me, first what I did was check the Begin Transaction. But unfortunately there were no problems in those components. But every time package execution was failed.
In this case we want to do some transaction using a connection and
commit or rollback that transaction using same connection but in
different task. So it’s essential to keep the same connection to do that
We can set this using Retain Same Connection property of the
connection. Set that property to True in the properties window of the
This will solve the above problem.