tFileOutputDelimited "don't create empty file" on but file created

[Anonymous]

Hello,
empty files are created although "don't create empty file" is checked on tFileOutputDelimited 😞
Am I missing something ?
Regards,
Didier

[Anonymous]

In fact, the file contains a line break. It means if input an empty value (empty string or null), it output an empty line to the file.
Perhaps you could report it to bug tracker.
Thanks

[Anonymous]

Hi All,

even i m getting this empty file issue, even though there's no data in my output file.

Can any1 pls reply on this.

[Swechchha]

I have similar job where i ticked the On Empty Delete option in tFileOutputDelinited.

After running this job, When I check the folder, all the files were showing even the empty ones, but when I refreshed the file explorer, all 0 byte files were gone. So try refreshing once.

Secondly, If I am using a tMap to split/filter output into many files and few of my files are going to be empty. Suppose I am also copying the generated files with tFileCopy to another location. In such case, these 0 byte files will not be deleted from destination (where you have copied the files). On hit and trial, It looks like tMap routes data into mupliple flows almost at same time, so folder might not be refreshed on time to delete empty files.

So, in such case make sure to copy files on destination only using tPostJob or OnSubJobOK.