sql server - SSIS Foreach ADO Enumerator with Data Flow Task & Script -

been working on day , driving me crazy. i'm new ssis (usually c# programmer) things don't work way i'd expect them :)

(tl;dr - how can use ado foreach enumerator , pass whole row variable data task (which holds script component) inside?)

scenario: using cdc splitter component in data task retrieve , split out inserts, updates , deletes cdc tables within database. assign each change package level object variable recordset.

taking inserts object variable want check condition on provided string data, , if true want email change someone.

to achieve dropped foreach container on surface , hooked inserts object variable. inside container dropped data flow task, , within data flow task dropped script component.

the idea if condition met current row, row added script component's output buffer. what's bugging me seems though way achieve map each column in row foreach loops variables collection. every example i've seen shows variables mapped starting index 0 etc. row has lot of columns , don't want create variables every column, seems wrong way.

so question is.. within ado enumerator foreach container, how pass current row (all columns) data task inside (and in turn script task within data task) ?

thanks advice...