run the SQL script in a Data FlowTask and output the results to a variable of type: Object, coped at package level.

Set up a For Each Task that enumerates the object variable into a second variable which holds the email address.

Within the FEL put your factory and use the emailaddress variable in expressions where needed.

Join the original DFT to the FEL and you are good to go.