The SQL Server Source step is used to retrieve the input from a Microsoft SQL Server. An account is required for this step to work.
Illustrated in the below image is a flow where the SQL Server Source step is used.
Adding a SQL Server Source Step
To add a SQL Server Source step in a flow, follow the below instructions:
1. Click on the plus icon as shown in the below image.
2. The below page will appear. Select or search for SQL Server as shown in the image below.
Configuring a SQL Server Source Step
Illustrated in the below image is the configuration that is available in the SQL Server Source step.
A connection is required for this step. Click on the highlighted plus button to create a new connection.
Type – The type of command to execute.
SQL Command – The SQL command to use. Use @parameters to inject parameters into the command.
Input Parameters – The Input Parameters to pass/inject to the SQL command. Click on the Add Row button to create Input Parameters.
Name – The parameter name.
SQL Type – The data type of the parameter. This can be selected from the dropdown list.
Value – The value for the parameter.
Default Value – The default value if the path does not exist.
Length – For VarChar, NVarChar, VarBinary types.
Precision – For Numeric and Decimal types.
Scale – For Numeric and Decimal, Time, DateTime2, DateTimeOffset types.
Request Timeout – The number of milliseconds before a request is considered failed. Leave at 0 for no timeout.
Throttling – Set when to throttle reading of the SQL records.
Every - Set how many records to throttle after.
For – Set the milliseconds to throttle for.