Classe BulkInsertTask
Provides the properties and methods for the Bulk Insert task, which is the quickest way to copy large amounts of data into a SQL Server table or view. This class cannot be inherited.
Hiérarchie d'héritage
System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.Task
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask
Espace de noms : Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
Assembly : Microsoft.SqlServer.BulkInsertTask (en Microsoft.SqlServer.BulkInsertTask.dll)
Syntaxe
'Déclaration
Public NotInheritable Class BulkInsertTask _
Inherits Task _
Implements IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend
'Utilisation
Dim instance As BulkInsertTask
public sealed class BulkInsertTask : Task,
IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend
public ref class BulkInsertTask sealed : public Task,
IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend
[<SealedAttribute>]
type BulkInsertTask =
class
inherit Task
interface IDTSComponentPersist
interface IDTSBulkInsertTask
interface IDTSBreakpointSite
interface IDTSSuspend
end
public final class BulkInsertTask extends Task implements IDTSComponentPersist, IDTSBulkInsertTask, IDTSBreakpointSite, IDTSSuspend
Le type BulkInsertTask expose les membres suivants.
Constructeurs
Nom | Description | |
---|---|---|
![]() |
BulkInsertTask | Initializes a new instance of the BulkInsertTask class. |
Haut de la page
Propriétés
Nom | Description | |
---|---|---|
![]() |
BatchSize | Gets or sets the number of rows in each batch. |
![]() |
CheckConstraints | Gets or sets a Boolean that indicates if 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. |
![]() |
DebugMode | Gets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled. |
![]() |
DestinationConnection | Gets or sets the name of the destination connection object. |
![]() |
DestinationTableName | Gets or sets the name of the destination table or view. |
![]() |
ExecutionValue | Returns a user-defined object. This field is read-only. (hérité de Task.) |
![]() |
FieldTerminator | Gets or sets the field terminator for use in char and widechar data files. |
![]() |
FireTriggers | Gets or sets a Boolean 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 Boolean that specifies how identity value or values in the imported data file are used for the identity column |
![]() |
KeepNulls | Gets or sets a Boolean that indicates whether empty columns should retain a nullune référence Null (Nothing dans Visual Basic) 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. |
![]() |
SqlStatement | Gets a String array that contains the Transact-SQL statement to run. |
![]() |
SuspendRequired | Gets or sets a Boolean that indicates whether tasks should suspend when they encounter a breakpoint. This value is set by the runtime engine for tasks and containers when a breakpoint is encountered. |
![]() |
TableLock | Gets or sets a Boolean that indicates whether the table is locked during the bulk insert operation. |
![]() |
UseFormatFile | Gets or sets a Boolean that indicates whether the Bulk Insert task uses a format file. |
![]() |
Version | *** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only. (hérité de Task.) |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
![]() |
AcceptBreakpointManager | Called by the run-time engine when a task or container is created, and is passed a BreakpointManager to enable the task to create, remove, and check the status of breakpoints. This method is called by the runtime and is not used in code. |
![]() |
CanUpdate | *** Member deprecated; see Remarks. *** A Boolean that indicates whether the new package XML can update the old package XML. (hérité de Task.) |
![]() |
Equals | Determines whether two object instances are equal. (hérité de DtsObject.) |
![]() |
Execute | Runs the Bulk Insert task. (remplace Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).) |
![]() |
GetConnectionID | Gets a String containing the ID of the connection. (hérité de Task.) |
![]() |
GetConnectionName | Gets a String containing the name of the connection. (hérité de Task.) |
![]() |
GetHashCode | Returns the hash code for this instance. (hérité de DtsObject.) |
![]() |
GetType | (hérité de Object.) |
![]() |
InitializeTask | Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (remplace Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).) |
![]() |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. |
![]() |
ResumeExecution | Resumes execution of the task after pausing. The task or container is resumed by the runtime engine. |
![]() |
SaveToXML | This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method. |
![]() |
SuspendExecution | Indicates that the executable needs to suspend. This method is called by the runtime engine. |
![]() |
ToString | (hérité de Object.) |
![]() |
Update | *** Member deprecated; see Remarks. *** This method updates the old package XML with the new package XML if CanUpdate is set to true. (hérité de Task.) |
![]() |
Validate | Verifies that the Bulk Insert task component is correctly configured. (remplace Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).) |
Haut de la page
Notes
For more information, see Tâche d'insertion en bloc.
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.