Bulk copy data constants specify the content of the data file used as a source for or target of a Microsoft® SQL Server™ bulk copy operation.
| Constant | Value | Description |
|---|---|---|
| SQLDMODataFile_ CommaDelimitedChar |
1 | Columns are delimited using a comma character. Each data row is delimited by a carriage return/linefeed character pair. |
| SQLDMODataFile_Default | 1 | SQLDMODataFile_ CommaDelimitedChar. |
| SQLDMODataFile_NativeFormat | 4 | SQL Server bulk copy native format. |
| SQLDMODataFile_ SpecialDelimitedChar |
3 | User-defined by the ColumnDelimiter and RowDelimiter properties of the BulkCopy object. |
| SQLDMODataFile_ TabDelimitedChar |
2 | Columns are delimited using a tab character. Each data row is delimited by a carriage return/linefeed character pair. |
| SQLDMODataFile_UseFormatFile | 5 | Bulk copy uses the file identified in the FormatFilePath property of the BulkCopy object. |