My requirement is to use excel file as my source file in BODS but the source file will be every time placed in a shared path in windows by the user.
I have to run the job every time so that the file placed in shared path will be automatically imported by the job and the file will become my source and all the data present in the file should be pushed to target.
Please help whether the above scenario will be possible or not and if possible, please suggest a process to do so.
Thank you :)