...
Option | Description |
|---|---|
Short filename field | The field name that contains the filename without path information but with an extension. |
Extension field | The field name that contains the extension of the filename. |
Path field | The field name that contains the path in operating system format. |
Size field | The field name that contains the size of the field. |
Is hidden field | The field name that contains if the file is hidden or not (boolean). |
Uri field | The field name that contains the URI. |
Root uri field | The field name that contains only the root part of the URI. |
Metadata Injection Support
All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.
Buttons
Function/Button | Description |
|---|---|
Show filenames | Displays a list of all the files selected. Note that if the transformation is to be run on a separate server, the result might be incorrect. |
Show file content | Displays the first lines of the text-file. Make sure that the file-format is correct. When in doubt, try both DOS and UNIX formats. |
Show content from first data line | Helps you position the data lines in complex text files with multiple header lines and more. |
Get fields | Allows you to guess the layout of the file. In case of a CSV file, this is performed almost automatically. When you select a file with fixed length fields, you must specify the field boundaries using a wizard. |
Preview rows | Preview the rows generated by this step. |