DataFileType Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
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 required file.
Syntax
object.DataFileType [=value]
Parts
object
An 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/line feed (CRLF) character pair. |
SQLDMODataFile_Default |
1 |
SQLDMODataFile_CommaDelimitedChar. |
SQLDMODataFile_NativeFormat |
4 |
The SQL Server bulk-copy native format. |
SQLDMODataFile_/SpecialDelimitedChar |
3 |
Delimiters are 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 CRLF character pair. |
SQLDMODataFile_/UseFormatFile |
5 |
Bulk copy uses the file identified in the FormatFilePath property of the BulkCopy object. |
Remarks
If DataFileType property is SQLDMODataFile_NativeFormat, use the Use6xCompatible property to specify SQL Server version compatibility.