Partager via


BulkCopy Object

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

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

Modèle objet SQL-DMO qui affiche l'objet en cours

Notes

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.

[!REMARQUE]

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.