Compartilhar via


Classe BulkInsertTask

Provides the properties and methods for the Bulk Insert task, which is the quickest way to copy large amounts of data into a SQL Server table or view. This class cannot be inherited.

Hierarquia de herança

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask

Namespace:  Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
Assembly:  Microsoft.SqlServer.BulkInsertTask (em Microsoft.SqlServer.BulkInsertTask.dll)

Sintaxe

'Declaração
Public NotInheritable Class BulkInsertTask _
    Inherits Task _
    Implements IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend
'Uso
Dim instance As BulkInsertTask
public sealed class BulkInsertTask : Task, 
    IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend
public ref class BulkInsertTask sealed : public Task, 
    IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend
[<SealedAttribute>]
type BulkInsertTask =  
    class 
        inherit Task 
        interface IDTSComponentPersist 
        interface IDTSBulkInsertTask 
        interface IDTSBreakpointSite 
        interface IDTSSuspend 
    end
public final class BulkInsertTask extends Task implements IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend

O tipo BulkInsertTask expõe os membros a seguir.

Construtores

  Nome Descrição
Método público BulkInsertTask Initializes a new instance of the BulkInsertTask class.

Início

Propriedades

  Nome Descrição
Propriedade pública BatchSize Gets or sets the number of rows in each batch.
Propriedade pública CheckConstraints Gets or sets a Boolean that indicates if you want to enforce table and column check constraints.
Propriedade pública CodePage Gets or sets the code page of the data in the data file.
Propriedade pública DataFileType Gets or sets a value from the DTSBulkInsert_DataFileType enumeration that indicates the data-type value to use in the load operation.
Propriedade pública DebugMode Gets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.
Propriedade pública DestinationConnection Gets or sets the name of the destination connection object.
Propriedade pública DestinationTableName Gets or sets the name of the destination table or view.
Propriedade pública ExecutionValue Returns a user-defined object. This field is read-only. (Herdado de Task.)
Propriedade pública FieldTerminator Gets or sets the field terminator for use in char and widechar data files.
Propriedade pública FireTriggers Gets or sets a Boolean that indicates whether the insert triggers should be executed on the table during the operation.
Propriedade pública FirstRow Gets or sets the first row from which to start copying.
Propriedade pública FormatFile Gets or sets the full path of a format file.
Propriedade pública KeepIdentity Gets or sets a Boolean that specifies how identity value or values in the imported data file are used for the identity column
Propriedade pública KeepNulls Gets or sets a Boolean that indicates whether empty columns should retain a nulluma referência nula (Nothing no Visual Basic) value during the bulk load operation, or insert default values into the columns.
Propriedade pública LastRow Gets or sets the number of the last row to copy.
Propriedade pública MaximumErrors Gets or sets the maximum number of errors that can occur before the bulk insert operation fails.
Propriedade pública RowTerminator Gets or sets the row terminator for use in char and widechar data files.
Propriedade pública SortedData Gets or sets the Order by clause in the bulk insert statement
Propriedade pública SourceConnection Gets or sets the name of the source connection object.
Propriedade pública SqlStatement Gets a String array that contains the Transact-SQL statement to run.
Propriedade pública SuspendRequired Gets or sets a Boolean that indicates whether tasks should suspend when they encounter a breakpoint. This value is set by the runtime engine for tasks and containers when a breakpoint is encountered.
Propriedade pública TableLock Gets or sets a Boolean that indicates whether the table is locked during the bulk insert operation.
Propriedade pública UseFormatFile Gets or sets a Boolean that indicates whether the Bulk Insert task uses a format file.
Propriedade pública Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Herdado de Task.)

Início

Métodos

  Nome Descrição
Método público AcceptBreakpointManager Called by the run-time engine when a task or container is created, and is passed a BreakpointManager to enable the task to create, remove, and check the status of breakpoints. This method is called by the runtime and is not used in code.
Método público CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Herdado de Task.)
Método público Equals Determines whether two object instances are equal. (Herdado de DtsObject.)
Método público Execute Runs the Bulk Insert task. (Substitui Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Método público GetConnectionID Gets a String containing the ID of the connection. (Herdado de Task.)
Método público GetConnectionName Gets a String containing the name of the connection. (Herdado de Task.)
Método público GetHashCode Returns the hash code for this instance. (Herdado de DtsObject.)
Método público GetType (Herdado de Object.)
Método público InitializeTask Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Substitui Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)
Método público LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Método público ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the runtime engine.
Método público SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Método público SuspendExecution Indicates that the executable needs to suspend. This method is called by the runtime engine.
Método público ToString (Herdado de Object.)
Método público Update *** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (Herdado de Task.)
Método público Validate Verifies that the Bulk Insert task component is correctly configured. (Substitui Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)

Início

Comentários

For more information, see Tarefa Inserção em Massa.

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Dts.Tasks.BulkInsertTask