Advertisement

02.25.2008 at 04:50PM PST, ID: 23192224
[x]
Attachment Details

The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION using SSIS

Asked by Brian_Sutherland in SQL Server 2005

Tags: Microsoft, SQL Server, 2005, SSIS

I have an Execute SQL task first and the query is Begin Transaction. I then have a dataflow that uses a Flat File Source, goes through a Derived Column transform, and loads into a table. After the dataflow I have another Execute SQL task and the query is Commit Transaction. The two Execute sql tasks use the same connection manager as well as the ole db task in the data flow. Why do I get the error:
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

thanksStart Free Trial
[+][-]02.25.2008 at 05:17PM PST, ID: 20980923

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Server 2005
Tags: Microsoft, SQL Server, 2005, SSIS
Sign Up Now!
Solution Provided By: chapmandew
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628