Skip to Content

BODS problem with flat files and folder rights

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.

bods.jpg (7.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    May 07, 2013 at 09:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07, 2013 at 09:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07, 2013 at 10:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Michael Hamm

      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

  • avatar image
    Former Member
    May 07, 2013 at 05:08 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 08, 2013 at 06:38 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 04, 2013 at 04:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.