MS SQL Server Bulk Loader

Description

The MS SQL Server Bulk Loader action can bulk load data from a file into MSSQL.

Options

General Tab

OptionDescription

Workflow action name

The name of the workflow action.

Connection

The database connection.

Edit…​

Edit the database connection.

New…​

Create a new database connection using the standard dialog.

Wizard…​

Create a new database connection using the wizard dialog.

Target schema

The target schema.

Target table name

The target table.

Truncate table

Whether or not to truncate the table before starting the bulk load.

Source File name

The file to bulk load into MSSQL.

Browse…​

Browse the filesystem to choose the source file.

Data file type

char, native, widechar, widenative

Fields terminated by

The field separation character.

Rows terminated by

The row termination character.

Advanced Tab

OptionDescription

Codepage

OEM, ACP, RAW, specific

Specific codepage

Code page to use when specific is selected.

Format file

Path to format file.

Browse

Browse the filesystem to choose a format file.

Fire triggers

Check constraints

Keep nulls

Keep identity

Tablock

Start at line

At which line to start.

End at line

At which line to end.

Order by

Which field to order with.

Direction

Ordering ascending (asc) or descending (desc).

Error file

Path to the error file.

Browse…​

Browse the filesystem to a error file location.

Add date time

Whether or not to add the date and time.

Max errors

Batch size

Rows per batch

Add file to result filenames