Hi, we are experiencing an issue when running an Integration Activity that uses the Excel Provider as the source provider.
When setting up the source provider, we are able to select the correct location from the file picker, in this example:
The local path for this on the host is:
G:\Domains\Sites\uat-ic.mydwsite1.com\Files\Files\Integration\ExcelImports\EcomGroups.xlsx
When running the activity however, we get an error saying the path is not a valid one.
The integration job fails with the following message:
'G:\Domains\Sites\uat-ic.mydwsite1.com\FilesFiles\Integration\ExcelImports\EcomGroups.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
One of the "\" is being removed it seems, which is breaking the path.
We have reproduced this error in DW 9.13.9 and 9.13.11
Is anybody else encountering a similar issue when using the Excel Provider as a source?