Table of Contents

Get DataReader

Provides a DataReader for reading a forward-only stream of rows from a SQL Server database.

img

Example img
This flow example shows a process that reads data from a database, splits records into multiple chunks, converts each chunk into CSV format, and appends it to a blob storage.
Actions used in the flow are: SQL Server Get DataReader, DataReader chunker, Create CSV file as byte array and Append to Blob.

Properties

Name Type Description
Title Optional The title or name of the command.
Connection Required The SQL Server Connection.
Dynamic connection Optional Use this option of you needs to use a connection from the Create Connection action.
SQL expression and parameters Required The command to execute along with any parameters.
Reader variable name Optional Name of the return variable.
Command timeout (sec) Optional The time limit for command execution before it times out. Default is 120 seconds.
Description Optional Additional notes or comments about the action or configuration.

Returns

IDataReader