...
Option | Description |
|---|---|
Name | The name of the output field |
Column | The name of the column in the Access table |
Type | The data type to convert to |
Format | The format or conversion mask to use in the data type conversion |
Length | The length of the output data type |
Precision | The precision of the output data type |
Currency | The currency symbol to use during data type conversion |
Decimal | The numeric decimal symbol to use during data type conversion |
Group | The numeric grouping symbol to use during data type conversion |
Trim type | The type of trimming to use during data type conversion |
Repeat | Repeat the column value of the previous row if the column value is empty (null) |
Metadata Injection Support
You can use the Metadata Injection supported fields with ETL Metadata Injection step to pass metadata to your transformation at runtime. The following Option and Value fields of the Microsoft Access step support metadata injection:
- Options: Filename is Defined in a Field, Get Filename from Field, File and Directory, Regular Expression, Exclude Regular Expression, Selected Files, Show Filenames, Additional Fields, and Add to Result Filename
- Values: Name, Column, Type, Format, Length, Precision, Currency, Decimal, Group, Trim Type, Short Filename, Extension, Path, Size, Is Hidden, and Last Modification