Transfer of data from a flat file to another flat file

[former_member212706]

Dear Experts,

     I am a beginner in BODS. I am using the SAP BODS 4.0 version. I have defined two file formats and am trying to transfer data from one flat file to other . But i am getting an error stating "Cannot open file . Check its path and permissions"only for the target file and not the source file.

Where am i going wrong here. Please advice.

Thanks,

Rajesh.

Message was edited by: Rajesh Jeyaram Raja

[Former Member · Accepted solution]

Hello

I suspect this is becuase you have defined the file location relative to your local PC rather than from the job server.  When a job executes it can only access resources (a file in your case) that it has direct access to, so if you have specified c:\temp (as an example), the job server (assuming its on another machine) won't be able to access it.

Michael

[vnovozhilov]

Hi Rajesh,

The answer is hidden in your Flat File configuration. Check what option has been choosen in Data File location - Local or Job Server. Once you know where the file resides, you may check if there is a permission issue.

Thank you,

Viacheslav.

[Former Member]

Hi Rajesh,

Check if the flat file is open when you are running the  job.

If the file is open, the job fails.

Regards,

Harish.