https://community.qlik.com/t5/Talend-Studio/Rejecting-invalid-data-records-and-write-bad-records-to-a-file/m-p/2327783#M97132 The need is to import CSV files and load the data into database and write all bad/invalid data to a separate csv file. My question is what is the best way to do this? Based on my understanding, I can either use "Trigger-&gt; On Component Error" or use tMap. Just wonder what is a better approach between these two or is there any other approach. Thanks. Sat, 16 Nov 2024 12:06:21 GMT Anonymous 2024-11-16T12:06:21Z https://community.qlik.com/t5/Talend-Studio/Rejecting-invalid-data-records-and-write-bad-records-to-a-file/m-p/2327783#M97132 The need is to import CSV files and load the data into database and write all bad/invalid data to a separate csv file. My question is what is the best way to do this? Based on my understanding, I can either use "Trigger-&gt; On Component Error" or use tMap. Just wonder what is a better approach between these two or is there any other approach. Thanks. Sat, 16 Nov 2024 12:06:21 GMT https://community.qlik.com/t5/Talend-Studio/Rejecting-invalid-data-records-and-write-bad-records-to-a-file/m-p/2327783#M97132 Anonymous 2024-11-16T12:06:21Z https://community.qlik.com/t5/Talend-Studio/Rejecting-invalid-data-records-and-write-bad-records-to-a-file/m-p/2327784#M97133 How are you determining the validity or your data? Talend offers several components you could use. <BR />For example there is a tSchemaComplianceCheck component. <BR />"Validates all input rows against a reference schema or checks type, nullability, length of rows against reference values. The validation can be carried out in full or partly." Wed, 13 Feb 2013 15:59:02 GMT https://community.qlik.com/t5/Talend-Studio/Rejecting-invalid-data-records-and-write-bad-records-to-a-file/m-p/2327784#M97133 Anonymous 2013-02-13T15:59:02Z