|
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. |
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. |
IfDbTableExists | | Action to take if the table already exists.
Keep (Default) = Leave the table and existing data untouched.
Truncate = Delete any existing records, but leave structure unchanged.
Recreate = Delete the table and recreate it with the defined structure. |
TableName | | (Required) The name of a database table. |
TableSchema | | Specifies the Etl Extract or Transform element that created the schema for this element.
This attribute is not required. When not filled in, the element expects the schema to be defined using the child element ColumnSchema. |