You can use the metadata injection supported fields with the ETL metadata injection step to pass metadata to your transformation at runtime. The following option fields and values in the Microsoft Excel Input step support metadata injection:
Options:
- File and Directory
- Regular Expression
- Exclude Regular Expression
- Is file Required
- Include subfolders
- Spreadsheet type
- Sheet name
- Sheet start row
- Sheet start col
Values:
- Name
- Type
- Length
- Precision
- Trim Type
- Repeat
- Format
- Currency
- Decimal
- Grouping