Since SSIS moves data through the process in Buffer pages you can't set the output of a row to have a dynamic destination within the same buffer. All rows in a buffer will go to the same destination. If you need to output rows to different destinations then you somehow have to take all rows for that destination and move them together. @ ways for example are

1) A conditional split task with logic to output records that go to the same destination together. Say you wanted to output files based on state then you would have 50 Conditions in your Conditional Split with 5 outputs. Each of these outputs would then map to a specific destination.

2) Run your data flow in a Loop and bring only the needed records into the dataflow.

a)SQL Task that would select the distinct values for the column in question

b)Loop through the SQL return set by distinct value

c)SQL query for data source stored in a variable

d)Second SQL variable that is Evaluated as an expression The expression would bring

your criteria and qury together.

e)Your source adapter would get its source query from the second variable.