IDTSBulkInsertTask Interface

 

This API supports the product 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)

public interface IDTSBulkInsertTask

NameDescription
System_CAPS_pubpropertyBatchSize

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the number of rows in each batch.

System_CAPS_pubpropertyCheckConstraints

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether you want to enforce table and column check constraints.

System_CAPS_pubpropertyCodePage

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the code page of the data in the data file.

System_CAPS_pubpropertyDataFileType

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value from the DTSBulkInsert_DataFileType enumeration that indicates the data-type value to use in the load operation.

System_CAPS_pubpropertyDestinationConnection

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the destination connection object.

System_CAPS_pubpropertyDestinationTableName

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the destination table or view.

System_CAPS_pubpropertyFieldTerminator

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the field terminator for use in char and widechar data files.

System_CAPS_pubpropertyFireTriggers

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the insert triggers should be executed on the table during the operation.

System_CAPS_pubpropertyFirstRow

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the first row from which to start copying.

System_CAPS_pubpropertyFormatFile

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the full path of a format file.

System_CAPS_pubpropertyKeepIdentity

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that specifies how identity value or values in the imported data file are used for the identity column.

System_CAPS_pubpropertyKeepNulls

This API supports the product infrastructure and is not intended to be used directly from your code. 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.

System_CAPS_pubpropertyLastRow

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the number of the last row to copy.

System_CAPS_pubpropertyMaximumErrors

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the maximum number of errors that can occur before the bulk insert operation fails.

System_CAPS_pubpropertyRowTerminator

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the row terminator for use in char and widechar data files.

System_CAPS_pubpropertySortedData

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the Order by clause in the bulk insert statement.

System_CAPS_pubpropertySourceConnection

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the source connection object.

System_CAPS_pubpropertyTableLock

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the table is locked during the bulk insert operation.

System_CAPS_pubpropertyUseFormatFile

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the Bulk Insert task uses a format file.

For more information, see BulkInsertTask.

Return to top
Show: