Devart SQL Server Source extracts data from SQL Server tables. It has the following custom properties:
Property |
Description |
|---|---|
CommandTimeout |
The wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data. Default value is 30. |
RetryCount |
The number of times to retry querying the data in case if it fails. Default value is 5. |
RetryInterval |
The number of seconds before repeating an attempt to query data. Default value is 1. |
SelectStatement |
An SQL SELECT statement that queries SQL Server database objects. |