XML file data can be connected to via PowerShell.
For File sources there are a number of settings needed to identify the setup of the flat file.
Fields /Link buttons
|
Folder or web site / Browse |
Specify UNC folder path or http/ftp site address |
|
File type filter |
Optional filter used in combo box listing files in folder |
| Timeout (not implemented for XML) | Enter the number of seconds to wait for a result from the source when executing source scripts (applies to import of metadata, previews and transfers).
Caution: Setting timeout to 0 is not recommended as it does not automatically free up resources when the source query does not return. |
| Row limit | Enter the maximum number of rows returned in data previews.
Caution: Setting row limit to 0 is not recommended as data previews might consume a lot of system memory resulting in poor performance or "System out of memory" error messages. |