# 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 |                                                |

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/workflows/actions/mssqlbulkload.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.