The Recordset destination creates and populates an in-memory ADO recordset. The shape of the recordset is defined by the input to the Recordset destination at design time.

You configure the Recordset destination by specifying the variable that stores the ADO recordset.

At run time, an ADO recordset is written to the variable of type, Object, that is specified in the VariableName property of the Recordset destination. The variable then makes the Recordset available outside the data flow, where it can be used by scripts and other package elements.

This source has one input. It does not support an error output.

 Configuring the Recordset Destination

You can set properties through SSIS Designer or programmatically.

The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:

• Common Properties
  
• Destination Custom Properties
  

For more information about how to set the properties, see How to: Set the Properties of a Data Flow Component.

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

 See Also

Concepts

Creating Package Data Flow
Integration Services Variables
Integration Services Destinations

Help and Information

Getting SQL Server 2008 Assistance