BulkInsertTask Members

  • Article

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.

The following tables list the members exposed by the BulkInsertTask type.

Public Constructors

  Name Description
BulkInsertTask Initializes a new instance of the BulkInsertTask class.

Top

Public Properties

  Name Description
ms214626.pubproperty(en-US,SQL.90).gif BatchSize Gets or sets the number of rows in each batch.
ms214626.pubproperty(en-US,SQL.90).gif CheckConstraints Gets or sets a Boolean that indicates if you want to enforce table and column check constraints.
ms214626.pubproperty(en-US,SQL.90).gif CodePage Gets or sets the code page of the data in the data file.
ms214626.pubproperty(en-US,SQL.90).gif DataFileType Gets or sets a value from the DTSBulkInsert_DataFileType enumeration that indicates the data-type value to use in the load operation.
ms214626.pubproperty(en-US,SQL.90).gif DebugMode Gets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.
ms214626.pubproperty(en-US,SQL.90).gif DestinationConnection Gets or sets the name of the destination connection object.
ms214626.pubproperty(en-US,SQL.90).gif DestinationTableName Gets or sets the name of the destination table or view.
ms214626.pubproperty(en-US,SQL.90).gif ExecutionValue  Returns a user-defined object. This field is read-only. (inherited from Task)
ms214626.pubproperty(en-US,SQL.90).gif FieldTerminator Gets or sets the field terminator for use in char and widechar data files.
ms214626.pubproperty(en-US,SQL.90).gif FireTriggers Gets or sets a Boolean that indicates whether the insert triggers should be executed on the table during the operation.
ms214626.pubproperty(en-US,SQL.90).gif FirstRow Gets or sets the first row from which to start copying.
ms214626.pubproperty(en-US,SQL.90).gif FormatFile Gets or sets the full path of a format file.
ms214626.pubproperty(en-US,SQL.90).gif KeepIdentity Gets or sets a Boolean that specifies how identity value or values in the imported data file are used for the identity column
ms214626.pubproperty(en-US,SQL.90).gif KeepNulls Gets or sets a Boolean that indicates whether empty columns should retain a null value during the bulk load operation, or insert default values into the columns.
ms214626.pubproperty(en-US,SQL.90).gif LastRow Gets or sets the number of the last row to copy.
ms214626.pubproperty(en-US,SQL.90).gif MaximumErrors Gets or sets the maximum number of errors that can occur before the bulk insert operation fails.
ms214626.pubproperty(en-US,SQL.90).gif RowTerminator Gets or sets the row terminator for use in char and widechar data files.
ms214626.pubproperty(en-US,SQL.90).gif SortedData Gets or sets the Order by clause in the bulk insert statement
ms214626.pubproperty(en-US,SQL.90).gif SourceConnection Gets or sets the name of the source connection object.
ms214626.pubproperty(en-US,SQL.90).gif SqlStatement Gets a String array that contains the Transact-SQL statement to run.
ms214626.pubproperty(en-US,SQL.90).gif 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.
ms214626.pubproperty(en-US,SQL.90).gif TableLock Gets or sets a Boolean that indicates whether the table is locked during the bulk insert operation.
ms214626.pubproperty(en-US,SQL.90).gif UseFormatFile Gets or sets a Boolean that indicates whether the Bulk Insert task uses a format file.
ms214626.pubproperty(en-US,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms214626.pubproperty(en-US,SQL.90).gif WaitForMe  Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms214626.pubmethod(en-US,SQL.90).gif 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.
ms214626.pubmethod(en-US,SQL.90).gif CanUpdate  (inherited from Task )
ms214626.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms214626.pubmethod(en-US,SQL.90).gif Execute Overridden. Runs the Bulk Insert task.
ms214626.pubmethod(en-US,SQL.90).gif GetConnectionID  (inherited from Task )
ms214626.pubmethod(en-US,SQL.90).gif GetConnectionName  (inherited from Task )
ms214626.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms214626.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms214626.pubmethod(en-US,SQL.90).gif InitializeTask Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code.
ms214626.pubmethod(en-US,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms214626.pubmethod(en-US,SQL.90).gifms214626.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms214626.pubmethod(en-US,SQL.90).gifms214626.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms214626.pubmethod(en-US,SQL.90).gifms214626.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms214626.pubmethod(en-US,SQL.90).gif ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the runtime engine.
ms214626.pubmethod(en-US,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms214626.pubmethod(en-US,SQL.90).gif SuspendExecution Indicates that the executable needs to suspend. This method is called by the runtime engine.
ms214626.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms214626.pubmethod(en-US,SQL.90).gif Update  (inherited from Task )
ms214626.pubmethod(en-US,SQL.90).gif Validate Overridden. Verifies that the Bulk Insert task component is correctly configured.

Top

Protected Methods

  Name Description
ms214626.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms214626.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

BulkInsertTask Class
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask Namespace