October 12, 2015 at 4:41 am
I have a package with 3 parallel data flow tasks added in a sequence container. I need to implement transaction such that, the transaction completes if all the 3 data flow tasks successfully execute. If any of the data flow task fails, then transaction should rollback.
October 12, 2015 at 4:49 am
dudekula.kareemulla (10/12/2015)
I have a package with 3 parallel data flow tasks added in a sequence container. I need to implement transaction such that, the transaction completes if all the 3 data flow tasks successfully execute. If any of the data flow task fails, then transaction should rollback.
This is a statement of requirements, not a question.
Presumably you have looked at the TransactionOption property? Does your question relate to that, or something else?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 12, 2015 at 5:40 am
am testing this package but its not working.
I took one sequence container and dragged and dropped data flow task 1, data flow task 2 and data flow task 3 and configured all three data flow tasks.
In the sequencee container's properties, I have set the following properties
Transaction: supported
Isolation: readcommited
On the three data flow task's properties, I have set the following properties
Transaction: supported
Isolation: readuncommited
When I run the package, the data flow task 1 fails but the data into data flow task 2 is still being inserted and committed.
How can I prevent the data flow tasks from committing the transactions even if one of the data flow tasks fail?
October 12, 2015 at 5:44 am
Try changing it to 'Required' on the container. Leave the data flows within as supported.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply