A wrapper for a system call to the bcp utility which writes a SQL Server table or query (T-SQL) to a file.
output file name
named list of connection arguments. See makeConnectArgs.
name of the source table when exporting from SQL Server
Transact-SQL query that returns a result set. Ignored if table is specified.
character separator for columns
character separator for rows--new lines
list of additional options to pass to the
bcp utility. See details.
arguments to pass system2
No return value. Operations from bcp are printed to console; see
... to redirect output
bcpOptions allows the user to include additional arguments for the
system2. Please refer to
The default options are set
to the defaults for
-b refers to
number of rows to write at a time; 10,000 to 50,000 is a
-a refers to size of packets to be sent in
-e refers to the maximum number of errors before failure.