FastBCP Command Builder

Set parameters and collect the built command line at the bottom of the page

Platform:

Connection Parameters

Short Description	Value	Parameter	Default
Connection Type *		--connectiontype	[none]
ODBC DSN		--dsn	[none]
OLE DB Provider		--provider	[none]
Server		--server	[none]
Conn. String		--sourceconnectstring	[none]
Trusted Auth?		--trusted	false
Username		--user	[none]
Password		--password	[none]
Database *		--database	[none]

Source Query/Table

Short Description	Value	Parameter	Default
File Input		--fileinput	[none]
SQL Query		--query	[none]
Source Schema		--sourceschema	[none]
Source Table		--sourcetable	[none]

Output Options

Short Description	Value	Parameter	Default
File Output * (extension will define the filetype : csv , json, parquet, xlsx or binary)		--fileoutput	[none]
Output Directory *		--directory	[none]
Timestamped ?		--timestamped	false

Format Options

Short Description	Value	Parameter	Default
Delimiter		--delimiter	\|
Use Quotes ?		--quotes	false
Date and DateTime Format		--dateformat	yyyy-MM-dd
Decimal Separator		--decimalseparator	.
Boolean Format		--boolformat	automatic
Encoding		--encoding	UTF-8
Remove Header?		--noheader	false

Advanced Parameters

Short Description	Value	Parameter	Default
Parallel Method		--method	None
Parallel Degree		--paralleldegree	-2
Distribute Key Column		--distributekeycolumn	[none]
Merge Temp Files		--merge	true
Run ID		--runid	[none]
Settings File		--settingsfile	FastBCP_Settings.json

License

Short Description	Value	Parameter	Default
License		--license	[none] if not provided, will use FastBCP.lic