Microsoft® SQL Server™ bulk copy operations can copy to or read from files containing data in a number of formats. Use the DataFileType property to indicate the format type of the file desired or in use.
object.DataFileType [= value]
object
Expression that evaluates to an object in the Applies To list
value
Specifies the data content of the target or source of the bulk copy operation as described in Settings
Long, enumerated
Read/write
HRESULT GetDataFileType(SQLDMO_DATAFILE_TYPE* pRetVal);
HRESULT SetDataFileType(SQLDMO_DATAFILE_TYPE NewValue);
| 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. |
When DataFileType property is SQLDMODataFile_NativeFormat, use the Use6xCompatible property to specify SQL Server version compatibility.