Hi, I 'm using Talend Open Studio for Data Integration v.6.1 and it seems that the reject link for the component tMSSqlOutput doesn't work properly. The flow is the following: tFileInputExcel -> tMap -> tMSSqlOutput -(rejects)-> tFileOutputDelimited.
Primary Keys are specified.
By using the action "Insert if not exist" I expect the component tMSSqlOutput to reject all the rows which PKs are already present in the table, but it doesn't happen. Rows are not inserted nor updated, yet nothing passes the Rejects link and nothing gets written in the output file.
Hi, The rejects row is used to gather the data that does NOT match the filter or are not valid for the expected output. This link allows you to track the data that could not be processed for any reason (wrong type, undefined null value, etc.) For your requirement, are you looking for the changed data? It looks like: targe DB-->tMap(Catch lookup inner rejected)-->output(to get the changed data) source DB--> Best regards Sabrina
