SSIS: Conditional Split result to variable

Question

I have condition where I need to feed conditional split result based on condition (will be just one int value) to variable. Can some one help how to do this?

My actual package (Data flow):

XML Source --> Conditional split (based on condition) 2 outputs..one result based on condition (will be just one int value) need to pass it on to variable. How to achieve this?

Answer 1

Pure SSIS way - consume your dataflow into a Recordset Destination and then iterate through it with ForEach Loop, assigning value to the desired variable.