SSIS Package getting and retrieving data from multiple sources

Question

So we have this client extract we have to do which ultimately will contain Order Data for Individuals. However, the Extract must also contain Enrollment information for that Individual.

I know I can...but how would I first extract the Order Data for a certain time period, then pass that result set in order to get the Enrollment information for those Individuals with Orders in that time period in order then to aggregate all those data touch points that will then need to be put together a pipe-delimited file and finally Secure FTPed to the Client.

I am more concerned about extracting the Order Data and then using it's result set, Data Flow, to then get those individuals enrollment information and aggregating all of those data touch points into a final file than I am about the back-end. I'll figure that piece out.

Thanks for your review and am hopeful for a reply.

Any resources...Web Sites...YouTubes...etc...would be GREATLY appreciated.