I would like to know what is the best way to truncate a flat file before integrating data.
I cannot use the "Truncate Target File" from the template, because the mapping is used in a loop.
I have tried to use a "Write a file" with no text in it, before the loop.
It nearly works... The problem is that an empty line is written at the beginning of the file, and data starts on the second line.