If the content that you are writing in the text file does not require tabular representation or any indentation, you can use a SSIS variable to store the final resultset and later bind the variable to send an email.

If this is not possible, you will have to use a persistent store such as a database table to store the result and later query your table to extract data bind the result set to downstream tasks