BulkInsertTask Members
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.
The following tables list the members exposed by the BulkInsertTask type.
Public Constructors
| Name | Description | |
|---|---|---|
| BulkInsertTask | Initializes a new instance of the BulkInsertTask class. |
Top
Public Properties
| Name | Description | |
|---|---|---|
.gif "ms214626.pubproperty(en-US,SQL.90).gif") |
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 | Returns the version of the task. This property is read-only. (inherited from Task) |
|
WaitForMe | Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task) |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms214626.pubmethod(en-US,SQL.90).gif") |
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 | (inherited from Task ) |
|
Equals | Overloaded. (inherited from DtsObject ) |
|
Execute | Overridden. Runs the Bulk Insert task. |
|
GetConnectionID | (inherited from Task ) |
|
GetConnectionName | (inherited from Task ) |
|
GetHashCode | Returns the hash code for this instance. (inherited from DtsObject) |
|
GetType | (inherited from Object ) |
|
InitializeTask | Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code. |
|
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. |
.gif "ms214626.static(en-US,SQL.90).gif") |
op_Equality | (inherited from DtsObject ) |
|
op_Inequality | (inherited from DtsObject ) |
|
ReferenceEquals | (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 | (inherited from Task ) |
|
Validate | Overridden. Verifies that the Bulk Insert task component is correctly configured. |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms214626.protmethod(en-US,SQL.90).gif") |
Finalize | (inherited from Object ) |
|
MemberwiseClone | (inherited from Object ) |
Top
See Also
Reference
BulkInsertTask Class
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask Namespace