DataFileType Property
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。
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.
構文
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. |
解説
If DataFileType property is SQLDMODataFile_NativeFormat, use the Use6xCompatible property to specify SQL Server version compatibility.
Applies To:
参照
関連項目
ColumnDelimiter Property
FormatFilePath Property
RowDelimiter Property
Use6xCompatible Property