CozyRocThere 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!
ADO.NET DataSet Destination
PASS Summit '10
November 8 - 11, 2010 Washington State Convention & Trade Center in Seattle, WA
CozyRoc will be exhibiting at the Premier Conference for SQL SERVER Professionals. Register with code CR3D and get $100 off.
CozyRoc SSIS+ has been nominated for the 2010 SQL Server Magazine Community Choice Awards, category "Best Business Intelligence & Reporting Product". Vote Now to help us win this prestigious award.