BulkInsertTask Class

 

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.

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

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

public sealed class BulkInsertTask : Task, IDTSComponentPersist, 
	IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend

NameDescription
System_CAPS_pubmethodBulkInsertTask()

Initializes a new instance of the BulkInsertTask class.

NameDescription
System_CAPS_pubpropertyBatchSize

Gets or sets the number of rows in each batch.

System_CAPS_pubpropertyCheckConstraints

Gets or sets a Boolean that indicates if you want to enforce table and column check constraints.

System_CAPS_pubpropertyCodePage

Gets or sets the code page of the data in the data file.

System_CAPS_pubpropertyDataFileType

Gets or sets a value from the DTSBulkInsert_DataFileType enumeration that indicates the data-type value to use in the load operation.

System_CAPS_pubpropertyDebugMode

Gets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.

System_CAPS_pubpropertyDestinationConnection

Gets or sets the name of the destination connection object.

System_CAPS_pubpropertyDestinationTableName

Gets or sets the name of the destination table or view.

System_CAPS_pubpropertyExecutionValue

Returns a user-defined object. This field is read-only. (Inherited from Task.)

System_CAPS_pubpropertyFieldTerminator

Gets or sets the field terminator for use in char and widechar data files.

System_CAPS_pubpropertyFireTriggers

Gets or sets a Boolean that indicates whether the insert triggers should be executed on the table during the operation.

System_CAPS_pubpropertyFirstRow

Gets or sets the first row from which to start copying.

System_CAPS_pubpropertyFormatFile

Gets or sets the full path of a format file.

System_CAPS_pubpropertyKeepIdentity

Gets or sets a Boolean that specifies how identity value or values in the imported data file are used for the identity column

System_CAPS_pubpropertyKeepNulls

Gets or sets a Boolean that indicates whether empty columns should retain a null value during the bulk load operation, or insert default values into the columns.

System_CAPS_pubpropertyLastRow

Gets or sets the number of the last row to copy.

System_CAPS_pubpropertyMaximumErrors

Gets or sets the maximum number of errors that can occur before the bulk insert operation fails.

System_CAPS_pubpropertyRowTerminator

Gets or sets the row terminator for use in char and widechar data files.

System_CAPS_pubpropertySortedData

Gets or sets the Order by clause in the bulk insert statement

System_CAPS_pubpropertySourceConnection

Gets or sets the name of the source connection object.

System_CAPS_pubpropertySqlStatement

Gets a String array that contains the Transact-SQL statement to run.

System_CAPS_pubpropertySuspendRequired

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.

System_CAPS_pubpropertyTableLock

Gets or sets a Boolean that indicates whether the table is locked during the bulk insert operation.

System_CAPS_pubpropertyTargetServerVersion

(Inherited from Task.)

System_CAPS_pubpropertyUseFormatFile

Gets or sets a Boolean that indicates whether the Bulk Insert task uses a format file.

System_CAPS_pubpropertyVersion

*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only.(Inherited from Task.)

NameDescription
System_CAPS_pubmethodAcceptBreakpointManager(BreakpointManager)

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.

System_CAPS_pubmethodCanUpdate(String)

*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML.(Inherited from Task.)

System_CAPS_pubmethodEquals(Object)

Determines whether two object instances are equal.(Inherited from DtsObject.)

System_CAPS_pubmethodExecute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)
System_CAPS_pubmethodGetConnectionID(Connections, String)

Gets a String containing the ID of the connection.(Inherited from Task.)

System_CAPS_pubmethodGetConnectionName(Connections, String)

Gets a String containing the name of the connection.(Inherited from Task.)

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from DtsObject.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodInitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)

Initializes the properties associated with the task. This method is called by the runtime and is not used in code.(Overrides Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)

System_CAPS_pubmethodLoadFromXML(XmlElement, IDTSInfoEvents)

This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.

System_CAPS_pubmethodResumeExecution()

Resumes execution of the task after pausing. The task or container is resumed by the runtime engine.

System_CAPS_pubmethodSaveToXML(XmlDocument, IDTSInfoEvents)

This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.

System_CAPS_pubmethodSuspendExecution()

Indicates that the executable needs to suspend. This method is called by the runtime engine.

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodUpdate(String)

*** Member deprecated; see Remarks. ***   This method updates the old package XML with the new package XML if CanUpdate is set to true.(Inherited from Task.)

System_CAPS_pubmethodValidate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)

Verifies that the Bulk Insert task component is correctly configured.(Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)

For more information, see Bulk Insert Task.

Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show: