BODS problem with flat files and folder rights
we have a problem loading a flat file with BODS.
The flat file is located on the job server (Win-Server) under the path D:\flatfile\flatfile.txt
When we execute the job we receive the following error: "Cannot open file D:\flatfile\flatfile.txt. Check its path and permissions."
Which user needs the rights to access the folder/file: the user which runs the job-server/bods-service or the user which uses Data Services Designer and executes the job?
Is the path correct?
Thanks in advance.
The user of Data Services service should have rights to the file share .
But in your case try to use a UNC path instead of letter drive.