I have file to file scenario where I am tranferring source file to FTP destination. Everything works fine, even files are getting transferred to FTP destination but we have one problem.
My source file (which is on SAP application) server is of csv type. When I do FTP, it is getting converted into XML format, as shown below.
FTP file Recordset> - <Row> <GDP>BE-WBO1-PROD-SAP</GDP> <ARBPL>BWHSPASP</ARBPL> <BUDAT>01/07/2009</BUDAT> <GMNGA>21.480,000</GMNGA> </Row> - <Row> <GDP>BE-WBO1-PROD-SAP</GDP> <ARBPL>BJET0011</ARBPL> <BUDAT>01/07/2009</BUDAT> <GMNGA>3.510,000</GMNGA> </Row> Source file, BE-WBO1-PROD-SAP;WHSPASP;01/07/2009;21.480,000
Is this normal ? Cann't I have same CSV as source?
I have changed FTP file extension to .txt or .csv but when I open file from FTP location, it always opens as xml format.