cancel
Showing results for 
Search instead for 
Did you mean: 

Infopackage Routine in flat file datasource

Former Member
0 Kudos

Hi,

There is a requirements to load the data from multiple flat files in folder into BI which source data is coming from other system. Each flat file has it own naming convention.

There are around more the 200 flat file (CSV.file) in folder,data source is flat file datasource.

Could any one help me in above issue.

Regards

RAM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I assume they'll be using FTP to send the files... You have the layout defined and naming convention as well...

One option would be to create a user and folder in the BW server for the FTP to use it and put all files in the same place... From here you can define different Infopackages to read those files at specific times during the day or whatever schedule you guys agree...

A thing with the naming convention... Try to avoid using timestamps on the names and keep the names to be always the same... That way you just overwrite the existing files, the space usage won't grow much and you can make the loads automatic with the same file names...

Just some ideas...