IDTSBulkInsertTask 介面

此 API 支援 SQL Server 2012 基礎結構，但無法直接從您的程式碼使用。

Defines the properties and methods for the Bulk Insert task.

命名空間：  Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
組件：  Microsoft.SqlServer.BulkInsertTask (在 Microsoft.SqlServer.BulkInsertTask.dll 中)

語法

'宣告
Public Interface IDTSBulkInsertTask
'用途
Dim instance As IDTSBulkInsertTask

public interface IDTSBulkInsertTask

public interface class IDTSBulkInsertTask

type IDTSBulkInsertTask =  interface end

public interface IDTSBulkInsertTask

IDTSBulkInsertTask 型別公開下列成員。

屬性

	名稱	說明
	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 nullnull 參考 (在 Visual Basic 中為 Nothing) 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.

上層

備註

For more information, see BulkInsertTask.

請參閱

參考

Microsoft.SqlServer.Dts.Tasks.BulkInsertTask 命名空間