Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DataReader Destination

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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 Integration Services package. To do this, you create a data flow that implements the DataReader destination.

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.

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, see Set the Properties of a Data Flow Component.

Integration Services icon (small)  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:


For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Community Additions

ADD
Show:
© 2015 Microsoft