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.