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.
Assembly: Microsoft.SqlServer.BulkInsertTask (in Microsoft.SqlServer.BulkInsertTask.dll)
Microsoft.SqlServer.Dts.Runtime::DtsObject
Microsoft.SqlServer.Dts.Runtime::Task
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask::BulkInsertTask
| Name | Description | |
|---|---|---|
![]() | BulkInsertTask() | Initializes a new instance of the BulkInsertTask class. |
| Name | Description | |
|---|---|---|
![]() | 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. (Inherited from 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 null 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. |
![]() | TargetServerVersion | (Inherited from Task.) |
![]() | 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.(Inherited from Task.) |
| Name | Description | |
|---|---|---|
![]() | AcceptBreakpointManager(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. |
![]() | CanUpdate(String^) | *** Member deprecated; see Remarks. *** A Boolean that indicates whether the new package XML can update the old package XML.(Inherited from Task.) |
![]() | Equals(Object^) | Determines whether two object instances are equal.(Inherited from DtsObject.) |
![]() | Execute(Connections^, VariableDispenser^, IDTSComponentEvents^, IDTSLogging^, Object^) | Runs the Bulk Insert task. (Overrides Task::Execute(Connections^, VariableDispenser^, IDTSComponentEvents^, IDTSLogging^, Object^).) |
![]() | GetConnectionID(Connections^, String^) | Gets a String containing the ID of the connection.(Inherited from Task.) |
![]() | GetConnectionName(Connections^, String^) | Gets a String containing the name of the connection.(Inherited from Task.) |
![]() | GetHashCode() | Returns the hash code for this instance.(Inherited from DtsObject.) |
![]() | GetType() | (Inherited from Object.) |
![]() | InitializeTask(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^).) |
![]() | LoadFromXML(XmlElement^, IDTSInfoEvents^) | This method is not callable by your application code. To load a package saved as .xml, use the Application::LoadPackage method. |
![]() | ResumeExecution() | Resumes execution of the task after pausing. The task or container is resumed by the runtime engine. |
![]() | SaveToXML(XmlDocument^, IDTSInfoEvents^) | 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() | (Inherited from Object.) |
![]() | Update(String^%) | |
![]() | Validate(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.

