Logging Overview

Parameter Logs targets using FastBCP_settings.json

In FastBCP can log informations in 3 modes :

• Console
• Database (MSSQL and PostgreSQL Only)
• File (or Map)

Tips

You can use several targets (sinks) at the same time.

You can adapt what and where you want to log using the FastBCP_settings.json file.

By default if no custom path is provided, FastBCP looks for the settings file in :

• the current directory (the working directory)
• the same directory where the FastBCP executable is located (the executable directory).

If this file is not present, FastBCP will use the console log only.

You can specify a custom path to the settings file using the -f or --settingsfile parameter.

Windows

.\FastBCP.exe `
  --connectiontype mssql `
  --server localhost `
  --database "tpch10_collation_bin2" `
  --trusted `
  --query "SELECT * FROM dbo.orders" `
  --directory "D:\temp" `
  --fileoutput "mssql_orders.csv" `
  --parallelmethod Ntile `
  --distributekeycolumn "o_orderkey" `
  --paralleldegree 7 `
  --settingsfile "D:\logs\config\FastBCP_settings.json"

Linux

./FastBCP \
  --connectiontype mssql \
  --server localhost \
  --database "tpch10_collation_bin2" \
  --trusted \
  --query "SELECT * FROM dbo.orders" \
  --directory "/data/temp" \
  --fileoutput "mssql_orders.csv" \
  --parallelmethod Ntile \
  --distributekeycolumn "o_orderkey" \
  --paralleldegree 7 \
  --settingsfile "/etc/fastbcp/FastBCP_settings.json"

Some settings files samples can be found in the Configuration Examples page.