Share via

IDTSBulkInsertTask Interface

  • Article

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

Defines the properties and methods for the Bulk Insert task.

Namespace:  Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
Assembly:  Microsoft.SqlServer.BulkInsertTask (in Microsoft.SqlServer.BulkInsertTask.dll)

Syntax

'Declaration
Public Interface IDTSBulkInsertTask
'Usage
Dim instance As IDTSBulkInsertTask

public interface IDTSBulkInsertTask

public interface class IDTSBulkInsertTask

type IDTSBulkInsertTask =  interface end

public interface IDTSBulkInsertTask

The IDTSBulkInsertTask type exposes the following members.

Properties

  Name Description
Public property BatchSize Infrastructure. Gets or sets the number of rows in each batch.
Public property CheckConstraints Infrastructure. Gets or sets a value that indicates whether you want to enforce table and column check constraints.
Public property CodePage Infrastructure. Gets or sets the code page of the data in the data file.
Public property DataFileType Infrastructure. Gets or sets a value from the DTSBulkInsert_DataFileType enumeration that indicates the data-type value to use in the load operation.
Public property DestinationConnection Infrastructure. Gets or sets the name of the destination connection object.
Public property DestinationTableName Infrastructure. Gets or sets the name of the destination table or view.
Public property FieldTerminator Infrastructure. Gets or sets the field terminator for use in char and widechar data files.
Public property FireTriggers Infrastructure. Gets or sets a value that indicates whether the insert triggers should be executed on the table during the operation.
Public property FirstRow Infrastructure. Gets or sets the first row from which to start copying.
Public property FormatFile Infrastructure. Gets or sets the full path of a format file.
Public property KeepIdentity Infrastructure. Gets or sets a value that specifies how identity value or values in the imported data file are used for the identity column.
Public property KeepNulls Infrastructure. Gets or sets a value that indicates whether empty columns should retain a nulla null reference (Nothing in Visual Basic) value during the bulk load operation, or insert default values into the columns.
Public property LastRow Infrastructure. Gets or sets the number of the last row to copy.
Public property MaximumErrors Infrastructure. Gets or sets the maximum number of errors that can occur before the bulk insert operation fails.
Public property RowTerminator Infrastructure. Gets or sets the row terminator for use in char and widechar data files.
Public property SortedData Infrastructure. Gets or sets the Order by clause in the bulk insert statement.
Public property SourceConnection Infrastructure. Gets or sets the name of the source connection object.
Public property TableLock Infrastructure. Gets or sets a value that indicates whether the table is locked during the bulk insert operation.
Public property UseFormatFile Infrastructure. Gets or sets a value that indicates whether the Bulk Insert task uses a format file.

Top

Remarks

For more information, see BulkInsertTask.

See Also

Reference

Microsoft.SqlServer.Dts.Tasks.BulkInsertTask Namespace