SQL Bulk Import

Basic Information

Node Settings

• Connection ( string, required) : A connection string or connection tag.

• Process table name (string, required) : The name of the table from the process to be imported to the database.

• Server Table name (string, required) : The name of the table that be created in the database from the table that is defined in a "Process table name" field.

• ID Column (string, optional) : The name of the id or primary key column

• Add Missing Columns (boolean, required) : When the Boolean value is "true", then the node will be able to import missing columns in the existing table in the database

• Ignore Missing Table (boolean, required) : When the Boolean value is "true" and the table from process not exist, then the node will be ignored.

• Included Columns (List<String>, optional) : Optional list of columns to import into the database

If using connection tag in connection setting make sure that tag exists in database!

Note that if ID Column is configured and the table already exists in SQL Server, then no additional constraints will be created. This property is therefore used only when the node creates table itself, or the primary key created manually.

Also note that this primary key will have option ignore duplicate keys set to on, which means that if existing data (key already import to sql server table) will be imported, nothing will happen.

Examples

Example 1

In this example table named Table_24_0 from the process will be saved to the sql server table named IndexCenPivot. No primary keys will be created and all the columns will be imported.

{
  "Conection": "<results>",
  "TableName": "Table_24_0",
  "ServerName": "IndexCenPivot",
  "id": null,
  "addColumns": true,
  "MissingTable": false,
  "IncludedColumns": []
}