|
| AllowNulls | | Determine whether null values are allowed in the column.
True = (Default) Nulls are allowed.
False = Nulls are not allowed.
|
| ColumnNames | | (Required) A list of column names, separated by commas. For example:
OrderID, CustomerID, EmployeeID, OrderDate |
| DefaultColumnValue | | The default value to use if the column does not contain value. |
| 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. |
| MaxLength | | The maximum number of characters allowed. |
| MinLength | | The minimum number of characters allowed. |
| ValidCharacters | | A case sensitive string of valid characters. Defaults to all characters.
For example, to limit to lower case a-f and 0-9 use:
abcdef0123456789
The character order of the string is not important. |