Merge tables
Merges data from a SQL Server source table or view into a target table.
This action provides a lightweight wrapper for the Merge statement in SQL Server. If you need to perform a complex MERGE statement, use the Execute command action and write a custom MERGE statement.
Properties
| Name | Type | Description |
|---|---|---|
| Title | Optional | A descriptive title for the action. |
| Connection | Required | The SQL Server Connection. |
| Dynamic connection | Optional | Use this option of you needs to use a connection from the Create Connection action. |
| Source | Required | Select or enter source table/view to merge from. |
| Target table | Required | Select or enter target table name. |
| Merge configuration | Required | Select or edit merge configuration. |
| Result variable name | Optional | Name of the variable returning number of rows affected. |
| 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. |
SQL Server: Videos / Getting started
This section contains videos to help you get started quickly working with Azure SQL / SQL Server using Flow.
Dump CSV file from Azure Blob container to Azure SQL table
This video demonstrates how to import all records from a CSV file into an Azure SQL table.
In the demo, no data import options (such as data type conversion, number or date formatting) are specified, meaning the data is imported as raw text.