O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required