Ever wanted to put some data in a Recordset Destination and then pull the data out at a later time in your package?
Sorry. No can do.
You can foreach through the record set and act on it in that way, but if you want to use it as if it were a source, no luck.
A Recordset Destination gets it metadata at design time from its predecesor. A recordset source wouldn't have that opportunity to set metadata.
You'll have to use raw files instead. Dump the data out to a raw file and then use a Raw File Source later in your package.
Seems like a workaround, but that's the way it is.
I just read a blog entry by Jamie Thomson (click here) and was interested to hear him say that the raw file adapter was designed for passing data between two different data flow tasks. He also talks about a way to create a script task as a source that loops through the recordset in memory and plops each row in the pipeline. Very clever.