AnsweredAssumed Answered

Cannot SFTP Txt file without losing line breaks

Question asked by heather.cookson345690 on Jul 5, 2016
Latest reply on Jul 25, 2016 by AsheeshSharma6371

Hi, I'm very new to Boomi so apologies if there is an easy answer to this question. We have created a txt file atom in Boomi which is SFTP'd over to another server but when the txt file is opened on the new server, the new line breaks are ignored so I cannot do a bulk insert into my sql db. I've googled this and it seems to suggest that the way to get around this is to ensure that the file is being sent via SFTP as an ASCII txt file rather than the default binary. Is that correct? If so, how do I ensure that is done? what settings do I need to change?

 

Thanks,

Heather

Outcomes