Conditional flow in my Data Flow?

Question

Conditional flow in my Data Flow?

JMI

SSChampion

Points: 11831
More actions
October 28, 2008 at 12:17 pm

#127324

Is it possible to
have a conditional flow in my Data Flow?
If there was an Error Output I want to populate my GlobalErrorCount variable
and write to my log table.
But if there is no Error Output
(PipelineBuffer.RowCount = 0)
I want to go a different route.

Viewing 4 posts - 1 through 3 (of 3 total)

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

Raj's Ten Centuries Points: 1044 More actions · Answer 1

If you are mapping error output to an error table, yes you could have an row count. Declare a variable in package variable and use this variable in row count task.

Hope this is helpfull,

Rajesh

JMI SSChampion Points: 11831 More actions · Answer 2

I know there is a Row Count component

but how do you implement conditional flow?

I can not have two paths with an Expression like:

@[User::vGlobalErrorCount] != 0

It only works in Control Flow.

JMI SSChampion Points: 11831 More actions · Answer 3

It looks like inside Data Flow there is no way

to make a decision whether to proceed or to stop

based on the RowCount value returned from Error Output.

In my case it's variable "ver1".

I did a test. It all is processed on row-by-row level.

I added a Script Component right after RowCount and

MsgBox pops up as many times as there are rows in a pipeline.

And the value of variable "ver1" is always 0 which is wrong.

As soon as I added Script Component in Control Flow

"ver1" value is 2 which is correct.

So in my opinion there are big limitations inside Data Flow.

You can't really make any decisions right away after you find some information.

You have to get out of Data Flow first.

Unless I still miss something...