I've attached a picture of the tip of my Data Flow iceberg. It's basically a SELECT source, a myriad conditional splits, and a destination. All destinations are the same table, the point is to simply decide what status to assign these objects based on the splits it took to get there.
The statuses (statii?) are getting assigned correctly, but there's a need to get the information about how the decision was reached into the same table. I was hoping to use some System::variable at this point ([name] of the destination object? ... of the last split decision?) and just insert that into the table as well, but I don't see any way to do that.
The only 2 ideas I've got so far are
1) Seed the available "rule" values in the original SELECT and draw from them in the destination mapping.
2) Derive the information manually just prior to each destination "leaf" node by inserting a derived column task just prior to the leaf with a hardcoded "rule" value.
The first is going to slow our flow down significantly (methinks) since there are almost 100 (albeit integer) values that would need to flow through the entire DF, the latter is going to incur a garboon of work.
Does anyone have any other ideas I should try? THANK YOU SSC!