Monday, July 27, 2015

Properties in SSIS


The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION ???


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.