BulkCopy Object

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。

The BulkCopy object represents the parameters of a single bulk copy command issued against a Microsoft SQL Server database.

Properties

CodePage Property	MaximumErrorsBeforeAbort Property
ColumnDelimiter Property	RowDelimiter Property
DataFilePath Property	ServerBCPDataFileType Property
DataFileType Property	ServerBCPKeepIdentity Property
ErrorFilePath Property	ServerBCPKeepNulls Property
ExportWideChar Property	SuspendIndexing Property
FirstRow Property	TruncateLog Property (BulkCopy)
FormatFilePath Property	Use6xCompatible Property
ImportRowsPerBatch Property	UseBulkCopyOption Property
IncludeIdentityValues Property	UseExistingConnection Property
LastRow Property	UseServerSideBCP Property
LogFilePath Property

Methods

Abort Method

SetCodePage Method

Events

BatchImported Event

RowsCopied Event

説明

The BulkCopy object is used as a parameter to the ImportData method of the Table object and the ExportData method of the Table and View objects.

With the BulkCopy object, you can:

• Specify format values for the data file used for bulk copy operations.

• Set bulk copy command parameters, such as error file name and maximum number of errors to allow before stopping.

• Stop an in-process bulk copy.

• Respond to bulk copy events to report the number of rows processed or the percent complete.

注
The BulkCopy object is compatible with instances of SQL Server version 7.0 and later. However, the BulkCopy2 object extends the functionality of the BulkCopy object for use with features that were added in SQL Server 2000.

関連項目

参照

BulkCopy2 Object

ExportData Method

ImportData Method