.png)
BulkInsertTask Class
SQL Server 2008 R2
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.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.Task
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask
Assembly: Microsoft.SqlServer.BulkInsertTask (in Microsoft.SqlServer.BulkInsertTask.dll)
The BulkInsertTask type exposes the following members.
| 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. |
| 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 | 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. (Inherited from Task.) |
| Equals | Determines whether two object instances are equal. (Inherited from DtsObject.) |
| Execute | Runs the Bulk Insert task. (Overrides Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).) |
| Finalize | (Inherited from Object.) |
| GetConnectionID | Gets a String containing the ID of the connection. (Inherited from Task.) |
| GetConnectionName | 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 | 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 | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. |
| MemberwiseClone | (Inherited from 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 | (Inherited from Object.) |
| Update | *** 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.) |
| Validate | Verifies that the Bulk Insert task component is correctly configured. (Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).) |
For more information, see Bulk Insert Task.
