In my Data Flow, (within my ForEach Loop container) I am using the Row Count component in a few places to capture any error outputs and need to accumulate the row counts in each place into a package variable. Then I will handle the appropriate action in the Control Flow, after the ForEach completes.
So I put the Row Count into a variable RowCount1 and right after that in the Data Flow, I have created a Script Component and placed the following in the PostExecute section.
Variables.ErrorRows1 = Variables.ErrorRows1 + Variables.RowCount1
I also tried Me.Variables... but that did not make a difference. I placed a MsgBox("test") and that did not appear either. It looks like PostExecute does not get called at all - and then the Data Flow freezes in yellow, although all of the components inside are all green.
Any suggestions are appreciated! Thank you.