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 |