Condividi tramite


DataFileType Property

Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

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.

Sintassi

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.

Osservazioni

If DataFileType property is SQLDMODataFile_NativeFormat, use the Use6xCompatible property to specify SQL Server version compatibility.

Applies To:

BulkCopy Object

Vedere anche

Riferimento

ColumnDelimiter Property
FormatFilePath Property
RowDelimiter Property
Use6xCompatible Property

Guida in linea e informazioni

Assistenza su SQL Server 2005