DSXchange

My parallel job is having a transformer stage and what ever comming from this transformer stage is directly FTP'd to a remote vista server.The file FTP'd is having newline charters at the end of the record. I am FTP'ng the file with content "AB" and when i open the FTP'd file in vista I am seeing Newline charaters at the end. How can I remove this newline characters. I am using FTP enterprise edition stage in my parallel job.

Welcome aboard. :D

Using binary mode rather than ASCII mode FTP should prevent the line terminators, unless your job design is generating them.

I am using FTP enterprise stage. Even after changing the mode to binary i am getting the Newline charaters at the end of my record. I have only one record in my FTP'd file, ie string AB. After AB i am getting NLNLNL.
My job is parallel job i am having FTP stage after transformer stage.

ray.wurlod wrote:Welcome aboard. :D

Using binary mode rather than ASCII mode FTP should prevent the line terminators, unless your job design is generating them. ...

Have you set the line terminator in the FTP stage to "none"?

It should be under Inputs|Property Tab, the 4th item down.

did try this option too. But it is inserting NLNLNL at the end.

bchau wrote:Have you set the line terminator in the FTP stage to "none"?

It should be under Inputs|Property Tab, the 4th item down.

Check the record delimiter defined in the source. It might be a case, where these newline character might be carried from the source. Check it by writing into a intermediate Sequential file stage. Check with od -db command.