In the current release, the following bcp syntax and options are available:
[database.]schema.table in data_file | out data_file
Specifies the number of bytes, per network packet, sent to and from the server.
Specifies the number of rows per batch of imported data.
Uses a character data type.
Specifies the database to connect to.
Causes the value passed to the sqlcmd -S option to be interpreted as a data source name (DSN). For more information, see "DSN Support in sqlcmd and bcp" in Connecting with sqlcmd.
Specifies the full path of an error file used to store any rows that the bcp utility cannot transfer from the file to the database.
Uses an identity value or values in the imported data file for the identity column.
Specifies the full path of a format file.
Specifies the number of the first row to export from a table or import from a data file.
Specifies that empty columns should retain a null value during the operation, rather than have any default values for the columns inserted.
Specifies a login timeout. The –l option specifies the number of seconds before a bcp login to SQL Server times out when you try to connect to a server. The default bcp time-out for login to SQL Server is 15 seconds. The login time-out must be a number between 0 and 65534. If the value supplied is not numeric or does not fall into that range, bcp generates an error message. A value of 0 specifies time-out to be infinite.
Specifies the number of the last row to export from a table or import from a data file.
Specifies the maximum number of syntax errors that can occur before the bcp operation is canceled.
Uses the native (database) data types of the data to perform the bulk-copy operation.
Specifies the password for the login ID.
Executes the SET QUOTED_IDENTIFIERS ON statement in the connection between the bcp utility and an instance of SQL Server.
Specifies the row terminator.
Specifies that currency, date, and time data is bulk copied into SQL Server using the regional format defined for the locale setting of the client computer.
Specifies the name of the SQL Server instance to connect to. Or, if -D is used, a DSN.
Specifies the field terminator.
Specifies that the bcp utility connect to SQL Server with a trusted connection (integrated security).
Specifies the login ID used to connect to SQL Server.
Reports the bcp utility version number and copyright.
Uses Unicode characters to perform the bulk copy operation.
In this release, Latin-1 and UTF-16 characters are supported.