Not all files are getting loaded in target

[A_San]

I am trying to load 2 files - one with one record and other with 10 records. But only the file with 10 records are getting loaded. I am expecting to see 11 records. Attached my tFileInputdelimited details. Please let me know what am I missing.

Appreciate any help.

[TRF]

Share your tDBOutput settings.
As it is called twice, if you have a "delete or truncate before" operation, the result is normal.

[A_San]

Yes, I have a truncate operation.Attached the screenshot.

But how do I keep the truncate option and still load all the files in one batch?

I want the truncate to happen when I load the next set of files and not for every file in one batch run.

SS9.PNG

[Anonymous · Accepted solution]

Put a tDbRow component before your file list and manually truncate the table.  Then change your tDbOutput action on table to default instead of truncate

[A_San]

Yes, that worked. Thank you!