IDTSBulkInsertTask-Schnittstelle
Diese API unterstützt die SQL Server 2012-Infrastruktur und ist nicht zur direkten Verwendung im Code bestimmt.
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
Der IDTSBulkInsertTask-Typ macht folgende Elemente verfügbar.
Eigenschaften
Name | Beschreibung | |
---|---|---|
BatchSize | Infrastruktur Gets or sets the number of rows in each batch. | |
CheckConstraints | Infrastruktur Gets or sets a value that indicates whether you want to enforce table and column check constraints. | |
CodePage | Infrastruktur Gets or sets the code page of the data in the data file. | |
DataFileType | Infrastruktur Gets or sets a value from the DTSBulkInsert_DataFileType enumeration that indicates the data-type value to use in the load operation. | |
DestinationConnection | Infrastruktur Gets or sets the name of the destination connection object. | |
DestinationTableName | Infrastruktur Gets or sets the name of the destination table or view. | |
FieldTerminator | Infrastruktur Gets or sets the field terminator for use in char and widechar data files. | |
FireTriggers | Infrastruktur Gets or sets a value that indicates whether the insert triggers should be executed on the table during the operation. | |
FirstRow | Infrastruktur Gets or sets the first row from which to start copying. | |
FormatFile | Infrastruktur Gets or sets the full path of a format file. | |
KeepIdentity | Infrastruktur Gets or sets a value that specifies how identity value or values in the imported data file are used for the identity column. | |
KeepNulls | Infrastruktur Gets or sets a value that indicates whether empty columns should retain a nullein NULL-Verweis (Nothing in Visual Basic) value during the bulk load operation, or insert default values into the columns. | |
LastRow | Infrastruktur Gets or sets the number of the last row to copy. | |
MaximumErrors | Infrastruktur Gets or sets the maximum number of errors that can occur before the bulk insert operation fails. | |
RowTerminator | Infrastruktur Gets or sets the row terminator for use in char and widechar data files. | |
SortedData | Infrastruktur Gets or sets the Order by clause in the bulk insert statement. | |
SourceConnection | Infrastruktur Gets or sets the name of the source connection object. | |
TableLock | Infrastruktur Gets or sets a value that indicates whether the table is locked during the bulk insert operation. | |
UseFormatFile | Infrastruktur Gets or sets a value that indicates whether the Bulk Insert task uses a format file. |
Zum Anfang
Hinweise
For more information, see BulkInsertTask.