Loading data into memory—Recordset Destination
In this recipe, the use of the Recordset Destination component is demonstrated. Although not often used, it could help to fix specific real-world issues. This destination component does not save data to an external data source. Instead, it saves data into a memory ADO recordset through a SSIS object data type variable. This data is stored temporarily during the package execution and prepared inside a Data Flow. In other words, data is extracted and transformed along the Data Flow and inserted into the memory through the Recordset Destination which is to be used in another Data Flow or event in the Control Flow. Usually this component is used in conjunction with the Foreach loop task located in the Control Flow to loop through each record and act on each. This component follows the same logic of the remaining destination components that gets it metadata at design time from the source. Therefore, it is not possible to create it at runtime.
