BulkCopy Object

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

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

SQL-DMO-Objektmodell, das das aktuelle Objekt anzeigt

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

Hinweise

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.
ms133968.note(de-de,SQL.90).gifHinweis:
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.

Siehe auch

Verweis

BulkCopy2 Object
ExportData Method
ImportData Method

Hilfe und Informationen

Informationsquellen für SQL Server 2005