Have worked with Windows Services for Unix 3.5 for a bit. When moving files between windows and Unix using BizTalk, SFU and the File Adapter is a preferred method over moving them using the FTP Adapter (preferred by me at least).
Found out yesterday that when an interchange is sent from windows to unix using the File Adapter, that there is not a translation of the line delimiter. In windows the line delimiter is CR LF. In Unix the line delimiter is LF.
I had seen that SAP would choke on a file that was sent using the CR LF. (This situation is when a text file is sent directly without using the Adapter for SAP). When the SAP process would run, it would throw an error and display an invalid character as the line termination. I had thought that this invalid character was LF only, that the CR LF was not being passed in (i.e., that SFU was translating the delimiter from the windows preferred form to the Unix preferred form). And I thought that SAP needed the CR LF.
Dumb logic, now that I look back. SAP wants the delimiter to be the LF only (only now is the big “Doh!”.
Solution? In the schema change the delimiter from CR LF to LF.
