topic Re: tMSSqlRow - Doesn't update database fields in Talend Studio

tMSSqlRow - Doesn't update database fields

AkeB0N0 — Fri, 20 Nov 2015 08:35:50 GMT

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.

Re: tMSSqlRow - Doesn't update database fields

Anonymous — Sat, 21 Nov 2015 01:56:28 GMT

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

Re: tMSSqlRow - Doesn't update database fields

AkeB0N0 — Mon, 23 Nov 2015 06:26:35 GMT

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.

Re: tMSSqlRow - Doesn't update database fields

Anonymous — Mon, 23 Nov 2015 07:47:01 GMT

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.