Some of the data file not getting inserted into database, but files moved to successful archive directory

[ganeshK]

Hi Experts,

I have a talend job which reads the files from directory , Insert into DB2 database and then move to archive directory.

When i have more files, some of the files not getting inserted, but files moved to successful archive directory and there is no error as well.

Please guide me is there any design issue. My design is below.

[Prakhar1]

what is the code you are using in tFileArchive to give the file path ?

also how you are reading the files in tDeliminited Input

[ganeshK]

Hi,

Below are the properties and code i am using for tDelimitedInput and tFileArchive.