Is it possible to load flat file data residing on a local machine via BODS 4.2 or flat file should reside on BODS server?

[Former Member]

Hi All,

I have a requirement to load data from flatfiles stored on particular location, on a machine on which BODS client istallation is there.

I am able to create a flat file format by browsing the file location and giving file name.I can view the file data also.

But when I execute the job, job failswith the error "Cannot open file <D:/BODS_flatfiles/result.txt>. Check its path and permissions".

Please let me know whether it is possible to load data from flat file on a local machine, which has BODS4.2 client installated on it or the flat file should reside in a path in BODS job server ?

Thanks,

Deepa

[Former Member · Accepted solution]

Flat file should reside where you job server is.

[former_member187605 · Accepted solution]

Or on a share.

[Former Member]

Thank you all for the replies.

[Former Member]

Hi Deepa,

If you get solution then please mark answer as correct and close the tread!

Thanks,

Swapnil

[Former Member]

you should share folder where you are keeping flat file with BODS job server so that BODS can read the file.