Advanced Parameters

This section covers advanced configuration options for FastBCP.

Run ID

The Run ID parameter --runid is a unique identifier for the current export operation. It can be used for tracking, logging, and monitoring purposes.

Information

If not specified, FastBCP will generate a unique Run ID automatically.

Tips

If possible, inject the RunId provided by the caller (e.g., SSIS, Airflow, or any scheduler that supports a run identifier). This will greatly facilitate log correlation and troubleshooting.

./FastBCP \
...
 --runid "export-2024-01-09-001" \
...

Syntax:

• Long form only: --runid "<unique_identifier>"

Log Level

The Log Level parameter --loglevel controls the verbosity of logging output during export operations.

Available values:

• Information (default): Standard logging with key operation details
• Debug: Verbose logging with detailed diagnostic information

./FastBCP \
...
 --loglevel "Debug" \
...

Syntax:

• Long form only: --loglevel "<Information|Debug>"

note

If a settings file is specified with --settingsfile, the log level defined in the settings file takes precedence unless overridden by the command-line parameter.

Information

See Logging Overview for detailed information about logging configuration and output.

Settings File

The Settings File parameter --settingsfile allows you to store all FastBCP parameters in a configuration file, making it easier to manage complex exports and reuse configurations.

./FastBCP \
...
 --settingsfile "/path/to/config/export-config.json" \
...

Syntax:

• Long form only: --settingsfile "<path_to_json_file>"

Information

See Logging Overview for examples of settings file configuration.

Complete Example

Here's a complete example using advanced parameters:

Windows

.\FastBCP.exe `
  --connectiontype "oraodp" `
  --server "localhost:1521/OraService" `
  --database "tpch" `
  --user "FastUser" `
  --password "FastPassword" `
  --sourceschema "TPCH" `
  --sourcetable "ORDERS" `
  --directory "D:\temp" `
  --fileoutput "orders.xlsx" `
  --encoding "UTF-8" `
  --parallelmethod RowId `
  --paralleldegree 7 `
  --merge false `
  --loglevel "Debug" `
  --runid "oracle_to_excel_parallel_rowid" `
  --settingsfile "C:\config\oracle-export.json"

Linux

./FastBCP \
  --connectiontype "oraodp" \
  --server "localhost:1521/OraService" \
  --database "tpch" \
  --user "FastUser" \
  --password "FastPassword" \
  --sourceschema "TPCH" \
  --sourcetable "ORDERS" \
  --directory "/temp" \
  --fileoutput "orders.xlsx" \
  --encoding "UTF-8" \
  --parallelmethod RowId \
  --paralleldegree 7 \
  --merge false \
  --loglevel "Debug" \
  --runid "oracle_to_excel_parallel_rowid" \
  --settingsfile "/config/oracle-export.json"

This example:

• Connects to an Oracle database using the RowId parallel method
• Exports ORDERS table to Excel format with UTF-8 encoding
• Uses 7 parallel threads with separate files (merge=false)
• Enables Debug logging for detailed diagnostics
• Uses a custom Run ID for tracking
• Loads additional configuration from a settings file