SQL-DMO
Bulk Copy Data Constants (SQLDMO_DATAFILE_TYPE)
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. |