|
Attribute |
API Type |
Default |
Description |
 |
BatchSize |
Int64 |
|
This value specifies whether all of the data is copied in a single transaction or in a series of smaller batches.
[.NET API Property: BatchSize] |
 |
CheckConstraints |
Boolean |
|
This value specifies whether constraint checking is enforced or ignored during bulk import of data.
[.NET API Property: CheckConstraints] |
 |
CodePage |
String |
|
This value specifies the code page of the data file if the data in the file contains relevant text or character data.
[.NET API Property: CodePage] |
 |
ConnectionName |
AstOleDbConnectionNode |
|
This value specifies a direct reference to the OLE DB connection that will be used to bulk insert the data.
[.NET API Property: Connection] |
 |
DataFileType |
BulkInsertTaskDataFileType |
|
This value specifies which data-file type the Bulk Insert task uses when importing the data.
[.NET API Property: DataFileType] |
 |
DelayValidation |
Boolean |
|
This value specifies whether the validation of the Dataflow task in SSIS should be delayed until the package is executed. DelayValidation is most often used when the ETL process references tables and other server assets that were created in an earlier stage of the data processing run.
[.NET API Property: DelayValidation] |
 |
Disabled |
Boolean |
|
This value specifies whether the item is disabled. The default value is False.
[.NET API Property: Disabled] |
 |
DisableEventHandlers |
Boolean |
|
This value specifies whether the event handlers for this task, container, or package should be prevented from executing. The default value is False.
[.NET API Property: DisableEventHandlers] |
 |
ExecutionValueVariableName |
AstVariableBaseNode |
|
Specifies a variable to hold the execution results of this component.
[.NET API Property: ExecutionValueVariable] |
 |
FailPackageOnFailure |
Boolean |
|
This value determines whether the container will fail when a container component fails. If this container corresponds to a package, then the only valid value is False.
[.NET API Property: FailPackageOnFailure] |
 |
FailParentOnFailure |
Boolean |
|
This value determines whether the parent container will fail when a child container failes. The default value is False.
[.NET API Property: FailParentOnFailure] |
 |
FieldTerminator |
Delimiter |
|
This value specifies which field terminator is used in char and widechar data files. The default is tab (\t).
[.NET API Property: FieldTerminator] |
 |
FireTriggers |
Boolean |
|
This value specifies whether insert triggers are executed on the table during the operation. The default is False. Set the value to True to fire the triggers.
[.NET API Property: FireTriggers] |
 |
FirstRow |
Int64 |
|
This value specifies the first row from which to start copying. The default value is 1 (i.e. the first row in the data file is the first row copied.)
[.NET API Property: FirstRow] |
 |
ForcedExecutionValue |
String |
|
If the ForceExecutionValue property is set to True, then the container will return the value stored in this property as its execution value. Otherwise, this value will be ignored. The default value for ForecedExecutionValue is 0.
[.NET API Property: ForcedExecutionValue] |
 |
ForcedExecutionValueDataType |
TypeCode |
|
This property specifies the data type of the value stored in the ForceExecutionValue property.
[.NET API Property: ForcedExecutionValueDataType] |
 |
ForceExecutionResult |
ForceExecutionResult |
|
This value indicates whether a specified execution result value will result if the container runs. The default value is None, which means that the container does not force a specified outcome.
[.NET API Property: ForceExecutionResult] |
 |
ForceExecutionValue |
Boolean |
|
Gets or sets a Boolean that indicates whether the execution value of the container should be forced to contain the value specified in the ForcedExecutionValue property.
[.NET API Property: ForceExecutionValue] |
 |
Id |
Guid |
|
Allows the developer to specify a unique identifier (GUID) for the package. This can be used to retain a consistent ID between builds.
[.NET API Property: Id] |
 |
IsolationLevel |
IsolationLevel |
|
Sets the Isolation Level which controls how Transactions behave for this container.
[.NET API Property: IsolationLevel] |
 |
KeepIdentity |
Boolean |
|
This value specifies whether the identity value or values specified in the source data are applied to the identity column in the destination table or view or ignored. The default value is True, meaning that the source identity values are used.
[.NET API Property: KeepIdentity] |
 |
KeepNulls |
Boolean |
|
This value specifies whether empty columns retain a null value or receive specifed default values during the bulk load operation.
[.NET API Property: KeepNulls] |
 |
Language |
Language |
|
This specifies the default language to be used by this task and its descendants.
[.NET API Property: Language] |
 |
LastRow |
Int64 |
|
This value specifies which row is the last to be copied.
[.NET API Property: LastRow] |
 |
LoggingMode |
LoggingMode |
|
This value specifies whether logging is enabled or disabled by the container or by the parent container. The default value is UseParentSetting.
[.NET API Property: LoggingMode] |
 |
MaxErrorCount |
Int32 |
|
This value specifies the maximum number of errors allowed to occur before a package is forced to stop running. The default value is 1.
[.NET API Property: MaximumErrorCount] |
 |
MaxErrors |
Int64 |
|
This value specifies the maximum number of errors allowed before the bulk insert operation is halted. A value of 0 means that there is no limit on the number of errors allowed.
[.NET API Property: MaximumErrors] |
 |
Name |
String |
|
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program.
[.NET API Property: Name] |
 |
RowTerminator |
Delimiter |
|
This value which row terminator is used in char and widechar data files. The default is newline (\n).
[.NET API Property: RowTerminator] |
 |
SortedData |
String |
|
This value specifies whether the data is sorted using an orber by clause in the bulk insert statement. The default value is False, meaning that the data is not sorted by an order by clause.
[.NET API Property: SortedData] |
 |
TableLock |
Boolean |
|
This value specifies whether the destination table is locked during the bulk insert operation. Set the value to True to lock the table.
[.NET API Property: TableLock] |
 |
TransactionMode |
ContainerTransactionMode |
|
This value specifies the transaction context in which this task will execute.
[.NET API Property: TransactionMode] |