Output
SQL Server Output
Writes the incoming rows into an existing SQL Server table and passes the same rows on to the next node.
When to use it
Use it at the end of a pipeline when the cleaned result has to land in a SQL Server table that other systems or reports read from.
In a pipeline
File InputFilter RowsSQL Server Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
Example
Load cleaned customers into dbo.Customers
- Target Table=dbo.Customers
- Write Mode=Replace existing rows
| CustomerId | Name | City |
|---|---|---|
| 101 | Acme Ltd | Leeds |
| 102 | Borne SA | Lyon |
| 103 | Corva Oy | Espoo |
| CustomerId | Name | City |
|---|---|---|
| 101 | Acme Ltd | Leeds |
| 102 | Borne SA | Lyon |
| 103 | Corva Oy | Espoo |
Replace deletes the table's existing rows and inserts the new ones inside a single transaction, so a failure rolls the whole write back.
Worth knowing
- The table has to exist already; the node inserts into it and never creates or alters it.
- Column names are matched to the table's columns, so rename columns upstream if they do not line up.
- A preview never writes. It reports how many rows would be written instead.
- Internal columns whose names start with two underscores are left out of the insert.