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
Option | Description |
---|---|
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
Option | Description |
---|---|
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 |