Process chain error due to # character in the file

While loading flat files on application server to BW targets via a process chain, the load to PSA may fail due to special characters in the file.

Thus the info package step itself will fail with Continue reading →

DTP Error due to date in DD.MM.YYYY format

Many times while doing flat file load, the date in the csv file is given in the format DD.MM.YYYY. When this data is loaded to PSA, it will load without any error. But if we try to load this to further targets via DTP, it will throw invalid date error.

To solve this problem, editing date in the csv file prior to loading is not a practical solution as the file can be huge with many distinct values or there are large number of such files.

Here you need to use a Continue reading →