BODS problem with flat files and folder rights

[mhf]

Hello,

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.

[Former Member · Accepted solution]

Hi,

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.

Thanks

Nawfal

[former_member208246]

Hi Michael

Repository which is created for you must have the privilege to read the flat file and load in to the specific target. Try changing the root directory if still the problem persist.

Thanks,

Sanjay

[Former Member]

Full Read access to the path for the Service Account from the Job Server would Suffice.

There is nothing as repository having access to a file share.

[mhf]

I gave the user which runs the bods-service on the server read/write rights and it worked. Also with the letter drive path D:\.. it worked.

thanks for the help.

[former_member182007]

Thats great to hear

Michael, you can close this thread.

-Deepak

[former_member190855]

Hi Michael

Canyou please give me the steps?

Thanks

Runali

[Former Member]

Hi Michael,

One more thing to further verify.The user under which the DS service starts, if local system account then that should be changed to a local admin account since system account is limited and does not have network resource access. So the DS

.server may not be able to access the file and communicate it to the client

across the network.

hope this helps.

[former_member208246]

Hi

To run the file successfully the read and write privilege must be granted to the specified user. Only if the user receives the entire access, it would be possible to import the data from the flat file even if it s placed in the different location

Best

Sanjay

[mhf]

Which user are you refering to? The user which runs the job-server/bods on the server or the user which runs the Data Services Client on a laptop and executes the job?

[former_member182007]

Michael - User should have read/write access to the network location from where DS will pick the file.

This is for the user which runs the job on DS.

Let us know your findings.

deep

[former_member182007]

Michael -

Place your file at the place where you have read/write access. also make sure file is close when you execute your job.

I faced same issue which was resolved when I placed my input .txt file at some other location.

let us knoe the findings

deep