tMSSqlRow - Doesn't update database fields

[AkeB0N0]

Dear friends,

I have job as follows. The job works well until tMSSqlRow component which is inserting records in the database. tMSSqlRow component should update specific column fields based on the iterating value by tFlowToIterate component. Could you please help me to solve this issue? Thanks.

[Anonymous]

Hello
From your screenshot, it shows no unmatched records are output, so tMssqlRow will not be fired. 

[AkeB0N0]

Dear Shong,
the process checking two tables from the system. If both table has same records do nothing. That is why the screen showing empty records. To test process, I change the records manually from database.

[Anonymous]

I see you use global variable in the query, for testing, does the query work if you set a fixed value? To me, if there exists unmatched rows, tMssqlRow will work and the query will be executed.