The SQL Server Destination step inserts or updates records in an SQL server. This step requires an account to work.
Illustrated in the below image is a flow where the SQL Server Destination step is used.
Adding a SQL Server Destination Step
To add a SQL Server Destination 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 Destination Step
Illustrated in the below image is the configuration that is available in the SQL Server Destination step.
A connection is required for this step. Click on the highlighted plus button to create a new connection.
Request Timeout
The number of milliseconds before a request is considered failed. Leave at 0 for no timeout.
Type
The type of command to execute. Click on the dropdown arrow to select from the list.
Insert Type
The Insert Type is used to insert new records in a table.
Object Name – The name of the database object to operate on.
Column Mappings – The record to map.
Path – The JSON path to the value in the record to use as the key.
Column – The name column to compare the value to.
SQL Type – The SQL defined type. Click on the dropdown arrow to select the type
Length – For VarChar, NVarChar, VarBinary types.
Precision – For Numeric and Decimal types.
Scale – For Numeric and Decimal, Time, DateTime2, DateTimeOffset types.
Update Type
The Update Type is used to modify the existing records in a table.
Object Name – The name of the database object to operate on.
Column Mappings – The record to column mappings.
Key Mappings – The record to key mappings.
Upsert Type
The Upsert Type is used to update an existing row if a specified value already exists in a table, and insert a new row if the specified value doesn't already exist
Object Name – The name of the database object to operate on.
Column Mappings – The record to column mappings.
Key Mappings – The record to key mappings.
Command Type
The Command Type is used type in a 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.
Stored Procedure Type
The Stored Procedure Type is used to type in a command to execute a saved SQL query.
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.