tdboutput doesn't update the database (sql server)

[r1691402258]

Hi there

I'm using tdbouput to update and insert to the database. but, the database doesn't update after the run

and I can see the output using tLogRow and it's correct output but didn't insert to the DB

can anyone figure out where is the problem?

thank you.

[anselmopeixoto]

Hello @r r 

Since you're using a tDBConnection and a tDBClose, I assume those tDBOutput components are linked to tDBConnection.

If that's the case, you'll probably need to add a tDBCommit component after the main subJob to persist the transaction on the database.

Another option would be enabling auto commit on tDBConnection advanced settings.