Bulk load into MSSQL
Description
The Bulk load into MSSQL action bulk loads data from a file into MSSQL.
Contrary to the transform bulk loaders, this action requires a pre-existing file that is bulk loaded to MS SQL.
Options
General tab
| Option | Description |
|---|---|
Action name | The name of the workflow action. |
Target Table | |
Connection | The database connection. |
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. |
Data file | |
Source File name | The file to bulk load into MSSQL. |
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. |
Add date time | Whether or not to add the date and time. |
Max errors | |
Batch size | |
Rows per batch | |
Add file to result filenames |