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
operation.
We can set this using Retain Same Connection property of the
connection. Set that property to True in the properties window of the
connection.
This will solve the above problem.
No comments:
Post a Comment