DataReader Destination

The DataReader destination exposes the data in a data flow by using the ADO.NET DataReader interface. The data can then be consumed by other applications. For example, you can configure the data source of a Reporting Services report to use the result of running a Microsoft SQL Server 2005 Integration Services (SSIS) package. To do this, you create a data flow that implements the DataReader destination. For more information about publishing data in a report by running a package that uses the DataReader destination, see Defining Report Datasets for Package Data from SQL Server Integration Services.

For information about accessing and reading values in the DataReader destination programmatically, see Loading the Output of a Local Package.

You can specify a time-out value for the DataReader destination and indicate whether the destination should fail if a time-out occurs. A time-out occurs if the application does not ask for data within the specified time.

The DataReader destination has one input. It does not support an error output.

Configuring the DataReader Destination

You can set properties through SSIS Designer or 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:

For more information about how to set properties, click one of the following topics:

See Also


DataReader Source
Creating Package Data Flow

Other Resources

Integration Services Sources

Help and Information

Getting SQL Server 2005 Assistance