Skip to Content

How to automatically import an excel file from a shared path to BODS, when the job starts?

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 :)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 04 at 03:24 PM

    Hi ,

    You can use substitution parameters and define the shared drive path in the substitution parameter, and use the substitution parameter variable wherever needed, so that you can pick the file from shared drive.

    Thanks,

    Madhumahesh

    Add comment
    10|10000 characters needed characters exceeded