Import csv - FileNotFoundException

LewiSOI said:

C:\Users\USER\Desktop\FOLDER\FOLDER\FILE.csvsysI

Two things with this path. First, it looks like this is a path local to your workstation and not to your Job Service. You need to ensure that the job Service can access the CSVSYS file and the CSV.

Secondly, there seems to be a typo at the end of the path. The trailing l shouldn't be there, shouldn't it?

Hello and thank you Markus I really appreciate your quick answer.

The end of he path it's ok in my document, the final 'l' was my mistake while I type the question.

Yes, its a local path but I dont know how to add this file to the  Job Service. How could I give acces to my CSVSYS and CSV to the Job Sever.

Thank you on more time.

You either put the files on a share accessible by the workstation (for using Synchronization Editor) and the Job Service, or you copy it to a location of choice on the Job Service and change the variable in your synchronization project to the location of choice after you have tested your project with the Synchronization Editor.

I'll prefer the first method.

You either put the files on a share accessible by the workstation (for using Synchronization Editor) and the Job Service, or you copy it to a location of choice on the Job Service and change the variable in your synchronization project to the location of choice after you have tested your project with the Synchronization Editor.

I'll prefer the first method.

I created a folder with shared permission but now, the process is not "FROZEN" now the process never ends and its always "RUN". I don't know what could be the problem :S. The csv file have 10 lines is not a heavy file.

Thank you so much for your help.

Did you check the Job Service Log for errors? Is the service able to access the files on the share? Please remember that the service by default runs under the system context, which makes network access problematic.