MS SQL Server Bulk Loader

    Options

    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

    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