SSIS How do I store dataflow data in a temporary table then attached it in an email?

Question

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.

1.My entire control flow

2.My data flow with few transformation tasks. I would like to know how to store data after Sort4 then I can store them into variables.

Answer 1

Thanks ALL of your responses I also find a solution. I use Recordset Destination this data destination to help me store my temporary data. This destination can be called outside dataflow mode. You also need to create a variable to store your data.