There is only one way for storing data in-memory when using the standard SSIS data flow components. It is based around the old ADO Recordset object and therefore limited only to 32bit package executions. We have implemented a new script component for storing data into in-memory ADO.NET DataSet object. Cheers!
Saturday, December 5, 2009 - 20:47