cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple flat files reading from Network

Former Member
0 Kudos

Hi,

I am trying to load multiple files from Network. My path looks like ( \\tpdevqa\data\ ) . I used wait_for_file('\tpdevqa\data\*.txt', 0,0,1,$filename) and replace_substr($filename, '/', '\\'). My file path is recognized but I am not able to load. Here is the error - Cannot open file <\\tpdevqa\data\71420551618841>. Check its path and permissions.

I followed this procedure. Selective Reading and Postprocessing

http://wiki.scn.sap.com/wiki/display/EIM/Selective+Reading+and+Postprocessing?original_fqdn=wiki.sdn...

Please through light on this  one - Thanks Chandra

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member27665
Active Participant
0 Kudos

Try to use the wildcard in the file loader.

For example,*.csv or *.xml

This will pull all the files in that folder.

Former Member
0 Kudos

.File

Former Member
0 Kudos

Your file should be placed in the same location as the job server.

Former Member
0 Kudos

Job Server is one Server and Flat files on another server. Its not one time job. I need to make SCD1 for these FF. I don't think i can move these FF on JS. Is there any alternative Method? - thanks

Former Member
0 Kudos

Change the account from system to admin so that it can access the flat file across the network.

services.msc > business objects data services

Former Member
0 Kudos

Thanks Arun!  JS is not installed on my system, so i am not able see BO under services. I will check on Monday and will be back with update. But I am able to load with normal FF loading with the same path   //tpdevqa/data/*841 about 5 million records still lot files are missing because no concatenated.  Still do you thinnk that SYSTEM/ADMIN issue?