IDTSBulkInsertTask Interface

Definition

Namespace:

Microsoft.SqlServer.Dts.Tasks.BulkInsertTask

Assembly:

Microsoft.SqlServer.BulkInsertTask.dll

Defines the properties and methods for the Bulk Insert task.

public interface class IDTSBulkInsertTask

public interface IDTSBulkInsertTask

type IDTSBulkInsertTask = interface

Public Interface IDTSBulkInsertTask

Derived

Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask

Remarks

For more information, see BulkInsertTask.

Properties

CheckConstraints	Gets or sets a value that indicates whether you want to enforce table and column check constraints.
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.