IDTSBulkInsertTask Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Defines the properties and methods for the Bulk Insert task.
public interface class IDTSBulkInsertTaskpublic interface IDTSBulkInsertTasktype IDTSBulkInsertTask = interfacePublic Interface IDTSBulkInsertTask- Derived
Remarks
For more information, see BulkInsertTask.
Properties
| BatchSize |
Gets or sets the number of rows in each batch. |
| CheckConstraints |
Gets or sets a value that indicates whether 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. |
| DestinationConnection |
Gets or sets the name of the destination connection object. |
| DestinationTableName |
Gets or sets the name of the destination table or view. |
| FieldTerminator |
Gets or sets the field terminator for use in char and widechar data files. |
| FireTriggers |
Gets or sets a value 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 value that specifies how identity value or values in the imported data file are used for the identity column. |
| KeepNulls |
Gets or sets a value 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. |
| TableLock |
Gets or sets a value that indicates whether the table is locked during the bulk insert operation. |
| UseFormatFile |
Gets or sets a value that indicates whether the Bulk Insert task uses a format file. |