DataFileType Property (SQL-DMO)

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]

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

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.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDataFileType(SQLDMO_DATAFILE_TYPE* pRetVal);

HRESULT SetDataFileType(SQLDMO_DATAFILE_TYPE NewValue);

See Also
ColumnDelimiter Property RowDelimiter Property
FormatFilePath Property Use6xCompatible Property

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.