Datatable to SQL Table
Writes a Datatable to an existing MSSQL Table.
Input
Source Table
| Name | Required | Description |
|---|---|---|
| Source Table | The source data destTable containing the data to be written to SQL |
Destination Table
| Name | Required | Description |
|---|---|---|
| SQL Connection | The connection to the destTable to be read | |
| Command Timeout (s) | Time in seconds before a SQL execution attempt is terminated. | |
| Database Name | The Destination Database / Initial Catalog | |
| Schema Name | The destination table's schema | |
| Table Name | The name of the destination SQL table to be written to |
String Mapping
| Name | Required | Description |
|---|---|---|
| Column Mapping | The column mapping config between the local data table and the SQL table |
Advanced Options
| Name | Required | Description |
|---|---|---|
| Batch Size | The maximum number of rows sent to the database server per batch. The default of 0 will allow all rows to be sent in one batch. |
Output
Output Message The resulting message from running this query.