Prevent creating an empty line at the end of flat file destination

Question

When inserting data into a flat file destination, an empty line is shown at the end. How can i remove it?

Answer 1

This line cannot be removed because the last line (before this line) need to ends with a row delimiter which is by default a carridge return + line feed CrLf. This causes to show this line.

So you have to write a script after inserting data is finish if this procedure is needed.