Clase 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.

Jerarquía de herencia

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

Espacio de nombres:  Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
Ensamblado:  Microsoft.SqlServer.BulkInsertTask (en Microsoft.SqlServer.BulkInsertTask.dll)

Sintaxis

'Declaración
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

El tipo BulkInsertTask expone los siguientes miembros.

Constructores

	Nombre	Descripción
	BulkInsertTask	Initializes a new instance of the BulkInsertTask class.

Arriba

Propiedades

	Nombre	Descripción
	BatchSize	Gets or sets the number of rows in each batch.
	CheckConstraints	Gets or sets a Boolean that indicates if you want to enforce table and column check constraints.
	CodePage	Gets or sets the code page of the data in the data file.
	DataFileType	Gets or sets a value from the DTSBulkInsert_DataFileType enumeration that indicates the data-type value to use in the load operation.
	DebugMode	Gets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.
	DestinationConnection	Gets or sets the name of the destination connection object.
	DestinationTableName	Gets or sets the name of the destination table or view.
	ExecutionValue	Returns a user-defined object. This field is read-only. (Se hereda de Task.)
	FieldTerminator	Gets or sets the field terminator for use in char and widechar data files.
	FireTriggers	Gets or sets a Boolean that indicates whether the insert triggers should be executed on the table during the operation.
	FirstRow	Gets or sets the first row from which to start copying.
	FormatFile	Gets or sets the full path of a format file.
	KeepIdentity	Gets or sets a Boolean that specifies how identity value or values in the imported data file are used for the identity column
	KeepNulls	Gets or sets a Boolean that indicates whether empty columns should retain a nullNothingnullptrunites una referencia NULL (Nothing en Visual Basic). value during the bulk load operation, or insert default values into the columns.
	LastRow	Gets or sets the number of the last row to copy.
	MaximumErrors	Gets or sets the maximum number of errors that can occur before the bulk insert operation fails.
	RowTerminator	Gets or sets the row terminator for use in char and widechar data files.
	SortedData	Gets or sets the Order by clause in the bulk insert statement
	SourceConnection	Gets or sets the name of the source connection object.
	SqlStatement	Gets a String array that contains the Transact-SQL statement to run.
	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.
	TableLock	Gets or sets a Boolean that indicates whether the table is locked during the bulk insert operation.
	UseFormatFile	Gets or sets a Boolean that indicates whether the Bulk Insert task uses a format file.
	Version	*** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Se hereda de Task.)

Arriba

Métodos

	Nombre	Descripción
	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.
	CanUpdate	*** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Se hereda de Task.)
	Equals	Determines whether two object instances are equal. (Se hereda de DtsObject.)
	Execute	Runs the Bulk Insert task. (Invalida Task. . :: . .Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
	Finalize	(Se hereda de Object.)
	GetConnectionID	Gets a String containing the ID of the connection. (Se hereda de Task.)
	GetConnectionName	Gets a String containing the name of the connection. (Se hereda de Task.)
	GetHashCode	Returns the hash code for this instance. (Se hereda de DtsObject.)
	GetType	(Se hereda de Object.)
	InitializeTask	Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Invalida Task. . :: . .InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)
	LoadFromXML	This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method.
	MemberwiseClone	(Se hereda de Object.)
	ResumeExecution	Resumes execution of the task after pausing. The task or container is resumed by the runtime engine.
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
	SuspendExecution	Indicates that the executable needs to suspend. This method is called by the runtime engine.
	ToString	(Se hereda de Object.)
	Update	*** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (Se hereda de Task.)
	Validate	Verifies that the Bulk Insert task component is correctly configured. (Invalida Task. . :: . .Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)

Arriba

Comentarios

For more information, see Tarea Inserción masiva.

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Dts.Tasks.BulkInsertTask