on 2022 May 02 9:04 AM
We have an BODS Job that loads data from various Excel files into a Oracle table. The problem that we have is that we need to reformat the Excel files before we load them, but we cannot do this manually so we created a macro to do this for us. We have installed Excel on the Jobserver and created a .bat file. The problem that we have is that when we execute the .bat file in BODS it hangs and nothing happens. We think the problem is that Excel is waiting for us to confirm something. Does anyone have an idea ?
BODS version 14.2.14
Regards Ulrike
Request clarification before answering.
Hi Ulrike,
are you able to run the batch script with your DS user manually (outside of DS) to check, if the setting really applies to your DS user?
Best regards
Marcus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
58 | |
10 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.