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]
| Part | Description |
|---|---|
| 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 |
| 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.
Long, enumerated
Read/write
HRESULT GetDataFileType(SQLDMO_DATAFILE_TYPE* pRetVal);
HRESULT SetDataFileType(SQLDMO_DATAFILE_TYPE NewValue);
| ColumnDelimiter Property | RowDelimiter Property |
| FormatFilePath Property | Use6xCompatible Property |