Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

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 (in Microsoft.SqlServer.BulkInsertTask.dll)
public sealed class BulkInsertTask : Task, 
	IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend

The BulkInsertTask type exposes the following members.

  NameDescription
Public methodBulkInsertTaskInitializes a new instance of the BulkInsertTask class.
Top
  NameDescription
Public propertyBatchSizeGets or sets the number of rows in each batch.
Public propertyCheckConstraintsGets or sets a Boolean that indicates if you want to enforce table and column check constraints.
Public propertyCodePageGets or sets the code page of the data in the data file.
Public propertyDataFileTypeGets or sets a value from the DTSBulkInsert_DataFileType enumeration that indicates the data-type value to use in the load operation.
Public propertyDebugModeGets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.
Public propertyDestinationConnectionGets or sets the name of the destination connection object.
Public propertyDestinationTableNameGets or sets the name of the destination table or view.
Public propertyExecutionValueReturns a user-defined object. This field is read-only. (Inherited from Task.)
Public propertyFieldTerminatorGets or sets the field terminator for use in char and widechar data files.
Public propertyFireTriggersGets or sets a Boolean that indicates whether the insert triggers should be executed on the table during the operation.
Public propertyFirstRowGets or sets the first row from which to start copying.
Public propertyFormatFileGets or sets the full path of a format file.
Public propertyKeepIdentityGets or sets a Boolean that specifies how identity value or values in the imported data file are used for the identity column
Public propertyKeepNullsGets 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.
Public propertyLastRowGets or sets the number of the last row to copy.
Public propertyMaximumErrorsGets or sets the maximum number of errors that can occur before the bulk insert operation fails.
Public propertyRowTerminatorGets or sets the row terminator for use in char and widechar data files.
Public propertySortedDataGets or sets the Order by clause in the bulk insert statement
Public propertySourceConnectionGets or sets the name of the source connection object.
Public propertySqlStatementGets a String array that contains the Transact-SQL statement to run.
Public propertySuspendRequiredGets 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.
Public propertyTableLockGets or sets a Boolean that indicates whether the table is locked during the bulk insert operation.
Public propertyUseFormatFileGets or sets a Boolean that indicates whether the Bulk Insert task uses a format file.
Public propertyVersion*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only. (Inherited from Task.)
Top
  NameDescription
Public methodAcceptBreakpointManagerCalled 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.
Public methodCanUpdate*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task.)
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodExecuteRuns the Bulk Insert task. (Overrides Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Protected methodFinalize (Inherited from Object.)
Public methodGetConnectionIDGets a String containing the ID of the connection. (Inherited from Task.)
Public methodGetConnectionNameGets a String containing the name of the connection. (Inherited from Task.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodInitializeTaskInitializes 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).)
Public methodLoadFromXMLThis method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodResumeExecutionResumes execution of the task after pausing. The task or container is resumed by the runtime engine.
Public methodSaveToXMLThis method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Public methodSuspendExecutionIndicates that the executable needs to suspend. This method is called by the runtime engine.
Public methodToString (Inherited from Object.)
Public methodUpdate*** 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.)
Public methodValidateVerifies that the Bulk Insert task component is correctly configured. (Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)
Top

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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.