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.

继承层次结构

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

命名空间:  Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
程序集:  Microsoft.SqlServer.BulkInsertTask(在 Microsoft.SqlServer.BulkInsertTask.dll 中)

语法

声明
Public NotInheritable Class BulkInsertTask _
    Inherits Task _
    Implements IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend
用法
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

BulkInsertTask 类型公开以下成员。

构造函数

  名称 说明
公共方法 BulkInsertTask Initializes a new instance of the BulkInsertTask class.

页首

属性

  名称 说明
公共属性 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. (从 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 nullNothingnullptrunitnull 引用(在 Visual Basic 中为 Nothing) 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. (从 Task 继承。)

页首

方法

  名称 说明
公共方法 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. (从 Task 继承。)
公共方法 Equals Determines whether two object instances are equal. (从 DtsObject 继承。)
公共方法 Execute Runs the Bulk Insert task. (覆盖 Task. . :: . .Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)。)
受保护方法 Finalize (从 Object 继承。)
公共方法 GetConnectionID Gets a String containing the ID of the connection. (从 Task 继承。)
公共方法 GetConnectionName Gets a String containing the name of the connection. (从 Task 继承。)
公共方法 GetHashCode Returns the hash code for this instance. (从 DtsObject 继承。)
公共方法 GetType (从 Object 继承。)
公共方法 InitializeTask Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (覆盖 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 (从 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 (从 Object 继承。)
公共方法 Update *** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (从 Task 继承。)
公共方法 Validate Verifies that the Bulk Insert task component is correctly configured. (覆盖 Task. . :: . .Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)。)

页首

注释

For more information, see 大容量插入任务.

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。