|AddErrorMessage||Adds two new columns to each row of the exception data.
rdErrorMessage is the reason the row could not be processed.
rdErrorSource is name of the source that returned the error.|
|BatchSize||The BatchSize attribute can be used to control the number of items (or rows) of a single database transaction. You can optimize your database commands to fit your specific configuration.
If set to zero, the system will process the entire datalayer as a single transaction.
BatchSize defaults to 1,000 rows per transaction.
|ConnectionID||Specifies a connection to a data source that is defined in the Settings.
For elements connecting to relational databases, default is the first Connection element in _settings.lgx.|
|DbKeyDataColumns||(Required) A set of one or more key column names in the destination database table.|
|EtlElementID||Enter the ID of the Extract or Transform element that contains the data to be processed.
If this attribute does not have a value, then the system will use the data from the last Extract or Transform element.|
|ExceptionDataID||Defines an ETL ID value that can be used to address the exception data that was removed by the filter.
The value of this attribute may be referenced by a DataLayer.ETL, LoadDbTable, SaveData, or any other element that supports the EtlElementID attribute.|
|ID||(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.|
|MaxErrors||The maximum number of errors allowed before the command will be stopped.
The default is no limit.
|TableName||(Required) The name of a database table.|