SQL-DMO
DataFileType Property
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.
Applies To
| BulkCopy Object |
Syntax
object.DataFileType [= value]
Parts
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
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetDataFileType(SQLDMO_DATAFILE_TYPE* pRetVal);
HRESULT SetDataFileType(SQLDMO_DATAFILE_TYPE NewValue);
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. |
Remarks
When DataFileType property is SQLDMODataFile_NativeFormat, use the Use6xCompatible property to specify SQL Server version compatibility.