SQL Server Integration Services Error : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (Microsoft OLE DB Provider for SQL Server)
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)
If the sql statements are like
SET “RetainSameConnection” property on the connection manager to true. This will fix the problem.
Reference : Pinal Dave (http://blog.SQLAuthority.com)