Package element: Bulk Insert Task
Properties
| Name | Value |
| ApartmentThreaded | True |
| BatchSize | 0 |
| CheckConstraints | True |
| CodePage | RAW |
| CreationName | Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask, Microsoft.SqlServer.BulkInsertTask, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 |
| DataFileType | 0 |
| DebugMode | False |
| DelayValidation | False |
| Description | Bulk Insert Task |
| DestinationConnection | localhost.Test |
| DestinationTableName | [Test].[dbo].[TestTable] |
| Disable | False |
| DisableEventHandlers | False |
| ExecutionDuration | 0 |
| ExecutionResult | Success |
| ExecutionStatus | None |
| FailPackageOnFailure | False |
| FailParentOnFailure | False |
| FieldTerminator | Tab |
| FireTriggers | False |
| FirstRow | 1 |
| ForcedExecutionValue | 0 |
| ForceExecutionResult | None |
| ForceExecutionValue | False |
| FormatFile | |
| HasExpressions | False |
| HostType | Task |
| ID | {E4D47AA2-9F96-41EF-8F77-0A85FC4FDBDA} |
| IsDefaultLocaleID | True |
| IsolationLevel | Serializable |
| KeepIdentity | False |
| KeepNulls | False |
| LastRow | 0 |
| LocaleID | Russian (Russia) |
| LoggingMode | UseParentSetting |
| MaximumErrorCount | 1 |
| MaximumErrors | 0 |
| Name | Bulk Insert Task |
| RowTerminator | {CR}{LF} |
| SortedData | |
| SourceConnection | Package.xml |
| SqlStatement | System.String[] |
| SuspendRequired | False |
| TableLock | False |
| TransactionOption | Supported |
| UseFormatFile | False |
| Version | 0 |
Elements
| Name | Description | Type |
| BulkInsertBegin | Invoked before the bulk insert statement is executed. | LogEntryInfos |
| BulkInsertEnd | Invoked after the bulk insert statement is executed. | LogEntryInfos |
| BulkInsertTaskInfo | Bulk Insert Task info | LogEntryInfos |
See also