• You can use either of the approach to solve this:

    1. Use a For each Loop container to load the text files and then move them to archive or delete them.

    2. If you have a business key in the table and text file, you can compare the business key in text file with table to validate that file has been previously loaded or not.

    3. Duplicate file will not have same name but they may have same data. Use approach #2.

    Vikash Kumar Singh || www.singhvikash.in