SSIS Control Flow

Question

SSIS Control Flow

Andy Leonard

SSChampion

Points: 10144
More actions
September 11, 2010 at 12:17 pm

#240120

Comments posted to this topic are about the item SSIS Control Flow
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

UMG Developer SSChampion Points: 13482 More actions · Answer 1

Nice question, thanks! It made me think about and better cement my understanding of transactions in SSIS, which is a good thing.

rene-500237 Hall of Fame Points: 3769 More actions · Answer 2

rene-500237

Hall of Fame

Points: 3769

September 13, 2010 at 1:20 am

#1219866

Good question.

VASUforSQL Old Hand Points: 324 More actions · Answer 3

This is reference to this Question :

The Sequence Container contains three Execute SQL Tasks (Execute SQL Task 1, Execute SQL Task 2, and Execute SQL Task 3) connected by OnSuccess Precedence Constraints: Execute SQL Task 1 ==> Execute SQL Task 2 ==> Execute SQL Task 3. And Execute SQL Task gets failed, then the updates of Execute SQL Tasks 1 and 2 will be rolledback or committed?

<p/>

It is answered as Commited.

<p/>

How it'll be commited..? It'll be rolled back right?. If these Exectue SQL Tasks are placed directly in the Control Flow, then updates of Execute SQL Task 1 and 2 will be committed when Task3 gets failed. But All three are placed in the container. So they will work as a Unit. All the tasks in Container will be failed, When one Task gets failed inside the container. So Updates of Task1 and Task2 will be rolled back. But It is answered as Commited.

<p>Please Explain..</p>

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

@dsvasudevan: I believe there is no explicit transaction, so the 3 tasks do not belong to the same transaction.

On-topic: great question!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 5

Good question...

The logic can be well understood as below:

For Parent : Transaction option = Required

For Child : Transaction option = Supported/Not Supported

Raunak J

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 6

Nice question. Took a minute to work out the logic in my head.

daveb87 Ten Centuries Points: 1025 More actions · Answer 7

daveb87

Ten Centuries

Points: 1025

September 13, 2010 at 7:55 am

#1220055

Nice Question!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

nice question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

pitVAX SSC-Addicted Points: 413 More actions · Answer 9

Nice question. It helps me awake to right settings and error handling for my simmilar SSIS task :w00t:.

Petr

__________________________________
Standing on the shoulders of giants ...