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.
BulkInsertTask 형식은 다음 멤버를 노출합니다.
메서드
| 이름 | 설명 | |
|---|---|---|
.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. |
|
CanUpdate | *** Member deprecated; see Remarks. *** A Boolean that indicates whether the new package XML can update the old package XML. (Task에서 상속됩니다.) |
|
Equals | Determines whether two object instances are equal. (DtsObject에서 상속됩니다.) |
|
Execute | Runs the Bulk Insert task. (Task. . :: . .Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)을(를) 재정의합니다.) |
.gif "보호된 메서드") |
Finalize | (Object에서 상속됩니다.) |
|
GetConnectionID | Gets a String containing the ID of the connection. (Task에서 상속됩니다.) |
|
GetConnectionName | Gets a String containing the name of the connection. (Task에서 상속됩니다.) |
|
GetHashCode | Returns the hash code for this instance. (DtsObject에서 상속됩니다.) |
|
GetType | (Object에서 상속됩니다.) |
|
InitializeTask | Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (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. |
|
MemberwiseClone | (Object에서 상속됩니다.) |
|
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 | (Object에서 상속됩니다.) |
|
Update | *** Member deprecated; see Remarks. *** This method updates the old package XML with the new package XML if CanUpdate is set to true. (Task에서 상속됩니다.) |
|
Validate | Verifies that the Bulk Insert task component is correctly configured. (Task. . :: . .Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)을(를) 재정의합니다.) |
맨 위로 이동
속성
| 이름 | 설명 | |
|---|---|---|
.gif "공용 속성") |
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. (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 nullNothingnullptrunitnull 참조(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. |
|
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. (Task에서 상속됩니다.) |
맨 위로 이동