tDBOutput generates the correct SQL but data is not in DB

[quad4x]

I'm trying to insert data into an MSSQL database using a delimited file to tDBOUtput.

Using a tJava, I'm printing the SQl generated using

   System.out.println(((String)globalMap.get("tDBOutput_1_QUERY")));

Generated statement:

INSERT INTO [system] ([inactive],[name],[description],[risktracksystemid],[addeddate],[fusionid]) VALUES ('0','New Test App','testing','','06-02-2022','b001Y00000qOtst')

However, the data isn't getting inserted.

When I run the same SQL in MS SQL Server Management Studio, the insert works.

[quad4x · Accepted solution]

Found that this works when I add 'tDBCommit' after the output. Not use to needing to commit changes to MSSQL database

[gjeremy1617088143]

yes you have to use a tDBCommit component on subjob ok link and tDBRollBack component on subjob error link, or you can set auto commit in advance option of the tDBConnection component.