Get DataReader
Provides a DataReader for reading a forward-only stream of rows from a SQL Server database.
Example
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. |