SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

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)

Menu
Exit mobile version