The CSV output format supports the following parameters:
headers | ||
Values: | ON | OFF | AUTO | |
Default: | AUTO | |
Description: | Write a header line containing the field names. | |
Details: | This parameter controls the CSV
header line that is output at the beginning of each file. The possible values for this parameter are:
|
|
Example: | -headers:OFF | |
oDQuotes | ||
Values: | ON | OFF | AUTO | |
Default: | AUTO | |
Description: | Enclose field values within double-quote characters ("). | |
Details: | This parameter controls whether or
not the CSV output format should enclose field values within
double-quote characters ("). The possible values for this parameter are:
|
|
Example: | -oDQuotes:ON | |
tabs | ||
Values: | ON | OFF | |
Default: | OFF | |
Description: | Write a tab character after each comma separator. | |
Details: | Setting this parameter to "ON" causes
the CSV output format to write a tab character after each comma
field separator, in order to improve readability of the CSV
output. Note that using tabs between field values might generate output that is not compatible with certain spreadsheet applications. |
|
Example: | -tabs:ON | |
oTsFormat | ||
Values: | timestamp format | |
Default: | yyyy-MM-dd hh:mm:ss | |
Description: | Format of timestamp values in the output CSV data. | |
Details: | This parameter specifies the date
and/or time format to use when formatting values of the TIMESTAMP data type. For more information on date and time formats, see Timestamp Format Specifiers. |
|
Example: | -oTsFormat:"MMM dd, yyyy" | |
oCodepage | ||
Values: | codepage ID (number) | |
Default: | 0 | |
Description: | Codepage of the output text. | |
Details: | 0 is the system codepage, -1 is UNICODE. | |
Example: | -oCodepage:1245 | |
fileMode | ||
Values: | 0 | 1 | 2 | |
Default: | 1 | |
Description: | Action to perform when an output file already exists. | |
Details: | This parameter controls the behavior
of the CSV output format when the into-entity specifies directly or
indirectly through the "multiplex" feature the name of a file that
already exists. The possible values for this parameter are:
|
|
Example: | -fileMode:0 | |
© 2004 Microsoft Corporation. All rights reserved.