SQL Server Integration Services Error : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (Microsoft OLE DB Provider for SQL Server)
Fix/Workaround/Solution:
Option 1:
To work around this problem, do not call the stored procedure by using ODBC Call syntax. You can call the stored procedure in may ways by using ADO. One of the methods is to call a stored procedure by using a command object. (View Example)
Option 2:
If the sql statements are like
BEGIN TRAN
SQL Statements
END TRAN
SET “RetainSameConnection” property on the connection manager to true. This will fix the problem.
Reference : Pinal Dave (https://blog.sqlauthority.com)
1 Comment. Leave new
Hi, thanks for your help! I’m having this problem when using vb6 + SQLServer 2005 + WinXP. Could you give an example of option 2, please?