SSIS如何将数据流数据存储在临时表中，然后将其附加到电子邮件中？

My goal is extract data from the existed table and do some basic transformation(e.g. derived column, Merge join). After that, I want to store data into a variable. Then, I will use a Script Task to write a send email program with C#, and call the variable to load those data into my email body content. But I am confused where I can store those temporary data after few steps transformation tasks. Any help, I am appreciated for it. My goal is extract data from the existed table